try this:
=IF(AND(F3=1,I8=4),"48%",IF(AND(F3=1,I8=3),"53%",I F(AND(F3=1,I8=2),"60",IF(AND(F3=2,I8=4),"65%",IF(A ND(F3=2,I8=3),"70",IF(AND(F3=2,I8=2),"70",0))))))

Hope it helps

"Wildwood" wrote:

Please help......this formula is returning a Value error.......what is wrong?

=IF(I8="1","0"),IF(AND(F3="1",I8=4),"48%",IF(AND(F 3="1",I8=3),"53%",IF(AND(F3="1",I8=2),"60%",IF(AND (F3="2",I8=4),"65%",IF(AND(F3="2",I8=3),"70%",IF(A ND(F3="2",I8=2),"70%"))))))