Go to the help index and take a look at
AND
for the proper syntax

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joe" (donotspam) wrote in message
...
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