OR(AI16<"No Response",AI16<"Get Back",AI16<"Returning",AI16<"Returned")
will ALWAYS return TRUE

Use AND(AI16<"No Response",AI16<"Get
Back",AI16<"Returning",AI16<"Returned")
to get TRUE when AI16 does not equal any of the four statuses.


"Gary" wrote:

What's wrong with this Conditional Formula?
=AND(OR(AI16<"No Response",AI16<"Get
Back",AI16<"Returning",AI16<"Returned")),(OR(AND (AQ16="Ph",AR160,AP160,AW16="",AX16=""),(AND(AQ1 6="Ph",AR160,AP160,AW16="")))).

My goal is to evaluate the first OR condition and if True then evaluate
either of the AND conditions as follows: AND(OR(if true), then calculate
(OR(AND(____),AND(____))

IF any of the first OR conditions are True, then perform the calculations in
either of the AND conditions, whichever one is True. I believe my syntax is
incorrect as I get error messages when pressing OK.