View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chiefs19 chiefs19 is offline
external usenet poster
 
Posts: 3
Default Nested IF(OR(AND) Statement with Two AND Conditions

I am using Excel 2003 and could use some assistance with a complex Nested IF
statement. Here is the criteria:

IF Salesorg=NAW1 AND Salesdivision=N4 AND SalesOffice=NWSA, then Group=UB
except when CustomerNbr=90000000 OR 90000001 OR 90000002, then Group=BA.

I have tried several different variations of Nested IF statements, but to no
avail. I do not know VBA, so this is not an option. Any help you can provide
would be greatly appreciated. Thank you.