Test of Multiple Conditions in an IF statement

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?
 
L

Luke M

You've posted this question several times now, Joe. Try reading some of the
responses.
 
S

Shane Devenshire

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

Testing for conditions with IF statement and AND function 1
Nested IF statements using AND / OR 2
Trouble constructing IF statement 1
Help with logical function 3
Need Excel count of 1 word if found in multi-word cells of column 1
MATCH not working in IF statement 6
Logical test in IF statement returning incorrect result 3
If Function - two conditions? 1

Top