Multiple if statements with And and Ors

JSpears

I have multiple Ifs and I seem to have tied myself in a knot.

=IF(NOT(ISDATE([Earliest Day 180]@row )), "Red"),

IF(AND([Send HIE]@row = "Green", ePrescribe@row = "Green", [Receive & Reconcile]@row = "Green", [Provide Patient Access]@row = "Green"), OR(PHCDE@row <> "Green", [Query PDMP]@row <> "Green"), "Blue"),

IF([Earliest Day 180]@row > TODAY(), IF(OR(ePrescribe@row = "Red", [Send HIE]@row = "Red", [Receive & Reconcile]@row = "Red", [Provide Patient Access]@row = "Red", PHCDE@row = "Red", [Query PDMP]@row = "Red"), "Red", "Yellow"),

IF(AND([Send HIE]@row = "Green", ePrescribe@row = "Green", [Receive & Reconcile]@row = "Green", [Provide Patient Access]@row = "Green", PHCDE@row = "Green", [Query PDMP]@row = "Green"), "Green", "Red")))))

I think I have a parenthesis or comma out of place but I'm not sure where. Any help would be appreciated

Paul Newcome

Try this:

=IF(NOT(ISDATE([Earliest Day 180]@row)), "Red", IF(AND([Send HIE]@row = "Green", ePrescribe@row = "Green", [Receive & Reconcile]@row = "Green", [Provide Patient Access]@row = "Green", OR(PHCDE@row <> "Green", [Query PDMP]@row <> "Green")), "Blue", IF([Earliest Day 180]@row > TODAY(), IF(OR(ePrescribe@row = "Red", [Send HIE]@row = "Red", [Receive & Reconcile]@row = "Red", [Provide Patient Access]@row = "Red", PHCDE@row = "Red", [Query PDMP]@row = "Red"), "Red", "Yellow"), IF(AND([Send HIE]@row = "Green", ePrescribe@row = "Green", [Receive & Reconcile]@row = "Green", [Provide Patient Access]@row = "Green", PHCDE@row = "Green", [Query PDMP]@row = "Green"), "Green", "Red")))