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")
 
Back
Top