CharmaineSilver

5 years agoQrew Member

# Formulas and checkboxes

Hi.

Just started on my first formula in QB and am having trouble with a check box.

Trying to say if half day is not checked add 1 day and if checked add 1.5 days.

Get the error message, expecting Boolean but found number on my second row of the formula.

The field is formula- numeric.

My first and last day fields are dates.

If([Half day],"No",

WeekdaySub([Last day of leave],[First day of leave])+1,

WeekdaySub([Last day of leave],[First day of leave])+1.5)

All help will be most appreciated

------------------------------

Charmaine Silverman

------------------------------

Just started on my first formula in QB and am having trouble with a check box.

Trying to say if half day is not checked add 1 day and if checked add 1.5 days.

Get the error message, expecting Boolean but found number on my second row of the formula.

The field is formula- numeric.

My first and last day fields are dates.

If([Half day],"No",

WeekdaySub([Last day of leave],[First day of leave])+1,

WeekdaySub([Last day of leave],[First day of leave])+1.5)

All help will be most appreciated

------------------------------

Charmaine Silverman

------------------------------