View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AND & OR in a IF loop AND & OR in a IF loop is offline
external usenet poster
 
Posts: 1
Default "AND" & "OR" in a IF loop

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.