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.
 
Back
Top