IF/AND formula

Cheryl C

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

Paul Newcome

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))

=Chris Palmer

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))

Paul Newcome

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))

=Chris Palmer

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))

Cheryl C

Perfect, thanks @Mr. Chris @Paul Newcome

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

Cheryl

=Chris Palmer

Excellent. Glad this worked for you.

Paul Newcome

Happy to help. 👍️