# IF/AND formula

Options

I need to calculate the number of Network Days based on a Leave Status but if a half day has been checked, it needs to just put 0.5. The formula I am currently using is:

=IF(AND([Half Day]@row = 1) [Leave Type]@row = "TOIL", "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row))

But I'm getting a #Unparsable error.

What am I doing wrong?

TIA

Cheryl

Tags:

• ✭✭✭✭✭✭
Options

The AND piece is just a little off.

=IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"), "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row))

• ✭✭✭✭✭
Options

Hi Cheryl,

Looks like you need some commas and one more parenthesis to initiate the IF AND

Give this a shot and see if it works for you:

=IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"), 0.5, NETWORKDAYS([Start Date]@row, [End Date]@row))

• ✭✭✭✭✭✭
Options

The AND piece is just a little off.

=IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"), "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row))

• ✭✭✭✭✭
Options

Hi Cheryl,

Looks like you need some commas and one more parenthesis to initiate the IF AND

Give this a shot and see if it works for you:

=IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"), 0.5, NETWORKDAYS([Start Date]@row, [End Date]@row))

• Options

Perfect, thanks @Mr. Chris @Paul Newcome

Worked perfectly. Knew it would have to be something simple.

Cheryl

• ✭✭✭✭✭
Options

Excellent. Glad this worked for you.

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!