Looking for a way to make these 10 nested functions work
 

I've researched a few options but havent been able to make anything work...
It looks like the maximum number of functions I can put together is 7...and I've got 10. Here is the formula I know would would if the limit were not 7....

=IF(C5="ATV",K5*9.5%,IF(C5="Cruiser",K5*9.8%,IF(C5 ="Dual",K5*9.8%,IF(C5="OHM",K5*9.5%,IF(C5="PWC",K5 *9.5%,IF(C5="Scooter",K5*9.8%,IF(C5="Sport",K5*9.8 %,IF(C5="Touring",K5*9.8%,IF(C5="Trailer",K5*9.8%, IF(C5="UTV",K5*9.8%))))))))))

I'd very much appreciate anyones help...

-T

I'm really desperate...can anyone help me????

-T

Well I've added a few more values now totaling 14...

I tried this and I get a "false" AND then the correct answer, obviously because the correct value is in the second IF statement.

=IF(C5="ATV Sport",J5*9.5%,IF(C5="ATV Utility",J5*9.5%,IF(C5="Cruiser",J5*9.8%,IF(C5="Cr uiser Touring",J5*9.8%,IF(C5="Dual Sport",J5*9.8%,IF(C5="MX",J5*9.5%,IF(C5="Offroad", J5*9.5%)))))))&IF(C5="PWC",J5*9.5%,IF(C5="Scooter" ,J5*9.8%,IF(C5="Standard",J5*9.8%,IF(C5="Sport",J5 *9.8%,IF(C5="Sport Touring",J5*9.8%,IF(C5="Trailer",J5*9.5%,IF(C5="UT V",J5*9.5%)))))))

The I tried this, but I get "formula contains an error"

=LOOKUP(C5,{"ATV Sport","ATV Utility","Cruiser","Cruiser Touring","Dual Sport","MX","Offroad","PWC","Scooter","Standard"," Sport","Sport Touring","Trailer","UTV"},{J5*9.5%,J5*9.5%,J5*9.8% ,J5*9.8%,J5*9.8%,J5*9.5%,J5*9.5%,J5*9.5%,J5*9.8%,J 5*9.8%,J5*9.8%,J5*9.8%,J5*9.5%,J5*9.5%})

I'm stumped.

-T