Nested IF AND

[Alex501]

Hi

I need a bit of help with a nested IF AND formula. I can get nested IF's to work with no problem, however if I add and into the mix it seems to go awry. The data i have is as follows;


[TABLE="width: 218"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2500[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2500[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1200[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1200[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1900[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1900[/TD]
[TD]No[/TD]
[/TR]
</tbody>[/TABLE]

The equation is as follows;

IF(AND(A2>2190,B2="No","Yes",IF(AND(A2>1825,B2="Yes","Yes","No"))))

What I'm expecting is that row 1 and 2 would be 'Yes', rows 3 and 4 would be 'No', row 5 'Yes' and row 6 'No' - however I keep getting errors in the equation and can't seem to see where it's going wrong.

Thanks for any help.

Alex

 

[ranman256]

dont use IIF, use a table, youve done half the work!

Put these values into a table and let the FUNCTiON pull the data.
the function will look it up. VLOOKUP.

 

[Selig]

You have your brackets in the wrong place. You need to close your AND statements after the second condition so that the "Yes" output is in the TRUE part of the IF statement, and so on:
=IF(AND(A2>2190,B2="No"),"Yes",IF(AND(A2>1825,B2="Yes"),"Yes","No"))

 

[Alex501]

You have your brackets in the wrong place. You need to close your AND statements after the second condition so that the "Yes" output is in the TRUE part of the IF statement, and so on:
=IF(AND(A2>2190,B2="No"),"Yes",IF(AND(A2>1825,B2="Yes"),"Yes","No"))

Hi Selig

Perfect, that did the trick. Thanks for your help.