Nested IF/AND Formula

Clay Watkins

I'm receiving an #UNPARSABLE error for the following formula:

=IF(AND([Completion Status]@row="Completed", [Actual End Date]@row<=TODAY()), "1",

IF(AND([Completion Status]@row="In Progress", [Actual End Date]@row> TODAY()), "2",

IF(AND([Completion Status]@row="Not Started", [Actual End Date]@row> TODAY ()), "3", "4")))

Based on the examples of similar formula, I think this is correct. What am I not seeing?

Mark Cronk

Your syntax looks right. When you place your cursor in the formula does it and the associated columns light up? Put each piece of the if statement into it's own row. Do they all produce a result?Check your column names. Confirm your end date column is set as a date. If none of that works, deleted the formula, save, and then retype it.

Mark