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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Joe" wrote:

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((D1415) AND (G14="Y") . . .) but Excel won't
accept that saying that the "logical test" is invalid. Both cells being
tested do exist.

Any ideas?
--
jws21