Thread: "AND" & "OR" in a IF loop
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default "AND" & "OR" in a IF loop
Maybe like this:

=IF(AND(AB1=5,OR(AC1={1,2})),"correct",IF(........ ...........

Biff

""AND" & "OR" in a IF loop" <"AND" & "OR" in a IF
wrote in message
...
how do I combine AND and OR in a nested IF statement.
eg: IF((AND(ab=5,ac=1)or(ac=2),"correct",if(........)) )
pls help.


Reply With QuoteReply With Quote