Try this:

=IF(OR(AND(G8=0,H8=0%),AND(G8=1,H8=30%),AND(G8=2 ,H8=40%),AND(G8=3,H8=50%),AND(G8=4,H8=65%),AND( G8=5,H8=75%)),"Successful",IF(AND(G8=6,H8<=80%), "DoesNotMeet",IF(AND(G8=6,H8<=89%),"Inconsistent" ,IF(AND(G8=6,H8<=114%),"Successful",IF(AND(G8=6, H8<125%),"Excellent",IF(AND(G8=6,H8=125%),"Excep tional","???"))))))

You can only nest a maximum of seven IF statements within one formula. Since
lots of your pairs of conditions yield the same result ("Successful"), we can
combine them within an OR statement. Also, there are many combinations of
values for G8 & H8 which fall outside your rules (maybe they can never occur
in your paricular worksheet). I have set the formula above to return ??? in
this case.

Hope this helps,

Hutch

"jonssmaster" wrote:

I'm stuck! I can't find a way to get this complex formula to work. First,
where am I going wrong? And second, is there an easier way to write it? I'm
guessing I have too many arguements. HELP!

=IF(AND(G8=0,H8=0%),"Successful",IF(AND(G8=1,H8= 30%),"Successful",IF(AND(G8=2,H8=40%),"Successful ",IF(AND(G8=3,H8=50%),"Successful",IF(AND(G8=4,H8 =65%),"Successful",IF(AND(G8=5,H8=75%),"Successf ul",IF(AND(G8=6,H8=90%),"Successful",IF(AND(g8=6 ,h8<=80%),"DoesNotMeet",IF(AND(G8=6,<=89%,"Incons istent",IF(AND(G8=6,H8<=114%"Successful",IF(AND(G 8=6,H8<=124%,"Excellent",IF(AND(G8=6,H8=125%,"E xceptional"))))))))))))