Why do I get a #Incorrect argument set error with the formula below/

=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

Answers