ExcelBanter - "AND" & "OR" in a IF loop

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - "AND" & "OR" in a IF loop (https://www.excelbanter.com/excel-worksheet-functions/108317-if-loop.html)

AND & OR in a IF loop

"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.

Biff

"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.

All times are GMT +1. The time now is 12:41 PM.