IF OR/AND Nesting Part 2

Carrie Tortorella

Hi - I just asked a IF OR/AND nesting question recently and it was answered. Then I tried to modify it slightly and it is unparseable. Could you please look at this one below?

=IF(OR(AND([Round #3 Price Sheet Status]@row = "Not Renewing"), AND([Account has Updated Renewal Added to TL]@row = 1,)), "Blue", IF([Price Sheet Deadline]@row >= TODAY(20), "Green", IF([Price Sheet Deadline]@row < TODAY(18), "Red", IF([Price Sheet Deadline]@row < TODAY(20), "Yellow"))))

Paul Newcome

The issue is with the second AND function

AND([Account has Updated Renewal Added to TL]@row = 1,)

Either the AND function needs removed along with the last comma before the closing parenthesis, or you forgot to add a second "logical statement" to the AND function.

Carrie Tortorella

So this would work? =IF(OR([Round #3 Price Sheet Status]@row = "Not Renewing"), IF([Contract Renewal Health]3[Account has Updated Renewal Added to TL]@row = 1,)), "Blue", IF([Price Sheet Deadline]@row >= TODAY(20), "Green", IF([Price Sheet Deadline]@row < TODAY(18), "Red", IF([Price Sheet Deadline]@row < TODAY(20), "Yellow")))

Paul Newcome

No. Now you are missing the AND function entirely, and you need to move the comma after the second criteria to between the first and second criteria.