View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Test of Multiple Conditions in an IF statement

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

Luke M
*Remember to click "yes" if this post helped you!*


"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