Why doesnt this formula work?

[zcemf64]

What is wrong with this formula?

=IF(AND(I2=OPP,J2=TL,H2<32.5,F2<=O2),"N",(IF(AND(I2=OPP,J2=TR),"",(IF(AND(I2=OPP,J2=BL,H2>327.5,F2<=O2),"N",(IF(AND(I2=OPP,J2=BR),"",(IF(AND(I2=SAME,J2=TL,H2>32.5,F2<=O2),"N",(IF(AND(I2=SAME,J2=TR,H2<147.5,F2<=O2),"N",(IF(AND(I2=SAME,J2=BL,H2<327.5,F2<=O2),"N",(IF(AND(I2=SAME,J2=BR,H2>212.5,F2<=O2),"N",(IF(AND(I2=VER,J2=TL,F2<=O2),"N",(IF(AND(I2=VER,J2=TR,H2<122.5,F2<=O2),"N",(IF(AND(I2=VER,J2=BL,H2>327.5,F2<=O2),"N",(IF(AND(I2=VER,I2=BR),"","")))))))))))))))))))))))

I typed this in the formula bar and apparently there's an error. I can't locate it though. Would really appreciate help

 

[anandvarma]

It exceeded 7 if conditions, try vlookup, lookup or index & match

 

[AlphaFrog]

I think this would do the same thing...
<font face=Courier New> =IF(OR(<br>        AND(I2=OPP,J2=TL,H2<32.5,F2<=O2),<br>        AND(I2=OPP,J2=BL,H2>327.5,F2<=O2),<br>        AND(I2=SAME,J2=TL,H2>32.5,F2<=O2),<br>        AND(I2=SAME,J2=TR,H2<147.5,F2<=O2),<br>        AND(I2=SAME,J2=BL,H2<327.5,F2<=O2),<br>        AND(I2=SAME,J2=BR,H2>212.5,F2<=O2),<br>        AND(I2=VER,J2=TL,F2<=O2),<br>        AND(I2=VER,J2=TR,H2<122.5,F2<=O2),<br>        AND(I2=VER,J2=BL,H2>327.5,F2<=O2)),<br>            "N","")</FONT>

 

[Biz]

Can you post sample data?

I would avoid hard coding values in formula like 32.5,327.5,147.5,137.5,212.25,122.5 becuz if your criteria changes then you manually need to update those values.

I would use cells references containing these values. Changes to criterias is so easy instead of changing the formula.

Biz

 

[zcemf64]

Thanks guys! Got it to work thanks to you.