View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe[_13_] Joe[_13_] is offline
external usenet poster
 
Posts: 4
Default Test of Multiple Conditions in an IF statement

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