"AND" & "OR" in a IF loop

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)> wrote in message
news:[email protected]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Voltage supply issue related to NUC PC Core i7 0
Conditional Formatting Formula? 5
OR in SUMPRODUCT formula 3
Excel Find length of side of triangle in Excel 12
blank cell instead of x 2
Establishing a Time Window 2
Function Has Too Many Arguments 4
An easier way using an array?? 1

Back
Top