G
Gary
What's wrong with this Conditional Formula?
=AND(OR(AI16<>"No Response",AI16<>"Get
Back",AI16<>"Returning",AI16<>"Returned")),(OR(AND(AQ16="Ph",AR16>0,AP16>0,AW16="",AX16=""),(AND(AQ16="Ph",AR16>0,AP16>0,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.
=AND(OR(AI16<>"No Response",AI16<>"Get
Back",AI16<>"Returning",AI16<>"Returned")),(OR(AND(AQ16="Ph",AR16>0,AP16>0,AW16="",AX16=""),(AND(AQ16="Ph",AR16>0,AP16>0,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.