Why do I get a #Incorrect argument set error with the formula below/
Carole M.
✭✭
=IF(Status@row = "Not Started", "Blue", IF(OR(AND(TODAY()>[End Date]@row, Status@row = "Not Started"), AND(TODAY()>[End Date]@row, Status@row = "In Progress")), "Red", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = "Not Started"), AND(TODAY(-5)>[End Date]@row, Status@row = "In Progress")), "Yellow", IF(Status@row = "Complete", "Green")))))
Best Answers
-
14 opening parentheses, 15 closing parentheses.
-
It's an easy mistake to make. Glad I could help.
Answers
-
14 opening parentheses, 15 closing parentheses.
-
Got it, thanks!
-
It's an easy mistake to make. Glad I could help.