conditional formatting - too many arguments?

[Gary]

Does this conditional formatting equation have too many arguments? If so, is
there a way to simplify the formula to reduce the number of arguments without
losing one of my tests? =AND(AND(AI11<>"No Response",AI11<>"Get
Back",AI11<>"Returning",AI11<>"Returned",AI11<>"Dead
Case"),(OR(AND(AQ11="",AR11>0,AW11=""),(AND(AP11>0,AR11>0,AQ11="MS",AW11=""),(AND(AR11>0,AW11="",DAYS360(AP11,TODAY())>0))))))
I get an unspecified error message when trying to enter it.

 

[Max]

Revised & lightly tested,
these 2 expressions were accepted in the CF's Formula Is:

(1) Basically as-is, except for removal of extraneous parens:
=AND(AND(AI11<>"No Response",AI11<>"Get
Back",AI11<>"Returning",AI11<>"Returned",AI11<>"Dead
Case"),OR(AND(AQ11="",AR11>0,AW11=""),AND(AP11>0,AR11>0,AQ11="MS",AW11=""),AND(AR11>0,AW11="",DAYS360(AP11,TODAY())>0)))

(2) A shorter one, simplifying the first AND criterion via using a defined
range "Response" and an ISERROR(MATCH(...))
=AND(ISERROR(MATCH(AI11,Response,0)),OR(AND(AQ11="",AR11>0,AW11=""),AND(AP11>0,AR11>0,AQ11="MS",AW11=""),AND(AR11>0,AW11="",DAYS360(AP11,TODAY())>0)))

where "Response" is a defined col range for the values:
No Response
Get Back
Returning
Returned
Dead Case

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[Gary]

Thank you MAX. Works like a charm! I used the first simplified revision,
simply because I'm not familiar with defined range.

 

[Max]

Good to hear. Thanks for feeding back & the rating.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik