Test of Multiple Conditions in an IF statement

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

What is the correct format to test for multiple conditions in an IF
statement? I want to test if both of two conditions are correct.

The format I am using is =IF((D14>15) AND (G14="Y") . . .) but Excel won't
accept that saying that the "logical test" is invalid. Both cells being
tested do exist.

Any ideas?
 
You've posted this question several times now, Joe. Try reading some of the
responses.
 
Hi,

=IF(AND(A1=1,B1="Red"),True,False)
or
=IF(OR(A1=1,B1="Red"),True,False)

You can have up to 30 tests inside the AND or OR in 2003.
 

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

Nested IF statements using AND / OR 2
Testing for conditions with IF statement and AND function 1
Trouble constructing IF statement 1
Help with logical function 3
IF function w/ 'and' condition 2
Need Excel count of 1 word if found in multi-word cells of column 1
IF OR AND in same conditional formula 2
Need help. Conditional formatting problems 1

Back
Top