I used the formula below with the data in cells A1:B5 and A7:B12. Now I am
getting a #Name? error. I'm not sure what I am doing incorrectly. I'm sure
I need to reference the table somehow, but I'm not sure how I do that.

=IF(G8<6,IF(H8VLOOKUP(G8,Table2,2),"Successful"," UNSUCCESSFUL"),VLOOKUP(H8,Table1,2))

"vezerid" wrote:

I would use VLOOKUP here and with two tables: one for G8=6 and one
for G8<6. Table 1:

0 DoesNotMeet
80% Inconsistent
90% Successful
115% Excellent
125% Exceptional

Table 2:
0 0
1 30%
2 40%
3 50%
4 65%
5 75%

Now your formula is compacted as follows, for the cases that G8 is < 6
and for when it is = 6.

=IF(G8<6,IF(H8VLOOKUP
(G8,Table2,2),"Successful","UNSUCCESSFUL"),VLOOKUP (H8,Table1,2))

Notes: I have added the "UNSUCCESSFUL" because your formula did not
say what would happen if, e.g. G8=4 and H8<65%.
Table1 and Table2 will be cell ranges like e.g. A1:B5 or C4:D9

HTH
Kostis Vezerides

On Nov 28, 7:36 pm, 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"))))))))))))