IF formula with AND and NOT

andhou

Hi,

I'm trying to get a "yes" or "no" answered based on the conditions below. I'm receiving the "incorrect argument set" error; however, I am unable to determine where the error is found. Thank you in advance!

1. If date is today or in the past
2. the status is: anything but complete

=IF(AND([Target Start Date]@row < TODAY(), IF(NOT(Status@row = "Complete"), "Yes", "No")))

Daryl Lee

Instead of using not, you can have the second statement be not equal to complete. The following should work:

=IF(AND([Target Start Date]@row < TODAY(), Status@row <> "Complete"), "Yes", "No")

Daryl Lee

Instead of using not, you can have the second statement be not equal to complete. The following should work:

=IF(AND([Target Start Date]@row < TODAY(), Status@row <> "Complete"), "Yes", "No")

andhou

Hi Daryl! Thank you!