More than 7 nested if loops.

[zcemf64]

Hey,

I am aware that excel does not allow more than 7 nested if loops. This is my current formula. I've just realized that my formula has to continue in this pattern up to 15 times. Any ideas on how to make it work?

=IF(AND(H3965>90,H3965<180,$O$2>0,$O$2<180,E3965>180,E3965<360),"TR1",(IF(AND(H3965>90,H3965<180),"TR",(IF(AND(H3965>0,H3965<90),"TL",(IF(AND(H3965>180,H3965<270,$O$2>0,$O$2<180,E3965>180,E3965<360),"BR1",(IF(AND(H3965>180,H3965<270),"BR",(IF(AND(H3965>270,H3965<360),"BL","")))))))))))

 

[VBACO]

I would probably go the custome function route. If you need help codeing I will be glad to help.

 

[Jerry Sullivan]

You might be able to accomplish this using the =CHOOSE() function.

For example, if your formula just had 4 Outcomes for which quadrant the number of degrees represents, you could use:
=CHOOSE(TRUNC(H3965/90,0)+1,"TR","TL","BL","BR")

You could extend this to your other two Outcomes shown in your OP, if you can make a formula that will evaluate to 5 and 6 in this format...
=CHOOSE(TRUNC(H3965/90,0)+1+(1*expressionTR1isTrue)+(2*expressionBR1isTrue),"TR","TL","BL","BR","TR1","BR1")

or split into 2 or more sets of Choices....
=If(expressionX,CHOOSE(expression,"TR1","BR1"), CHOOSE(TRUNC(H3965/90,0)+1,"TR","TL","BL","BR"))

Depending on your pattern that repeats 15 times, the "expression" parts might be simple or nearly impossible.

Good luck!