Nested IF statements using AND / OR

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have successfully nested IF statement in the past, but my current task is
frustrating me. I want to test for two conditions. if both are present, I
want the results of a cell's value to X.

If both aren't present, I want to test for a third condition. If the third
condition is present, I want the cell's value to also be X.

If neither the two conditions exist or the one condtion exists, I want the
cell to display Y.

Here is what my formula looks like

=IF(((D14>15) AND (G14="Y")),((I14*N14)/12),IF(C14>.8,((I14*N14)/12),""))

The first part, the logical statement is coming back invalid.

Can someone help? Thanks.
 
AND (as well as OR, MOD, etc.) is not an operator as it is in most
programming languages... it is a function. So when you wrote this...

(D14>15) AND (G14="Y")

it should have been this...

AND(D14>15,G14="Y")
 
Syntax for AND is
AND(test1, test2, test3, ....)

Your formula rewritten:
=IF(OR(C14>0.8,AND(D14>15,G14="Y"),(I14*N14)/12),"Y")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Testing for conditions with IF statement and AND function 1
Trouble constructing IF statement 1
Test of Multiple Conditions in an IF statement 3
nested IF without repeating the condition? 1
IF/OR Logic Function 7
Simple nested if and statement 2
Nested IF 2
IF OR AND in same conditional formula 2

Back
Top