Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 Last edited by mrtoyz : July 9th 10 at 04:44 AM |
#2
|
|||
|
|||
I'm really desperate...can anyone help me????
-T |
#3
|
|||
|
|||
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 Last edited by mrtoyz : July 9th 10 at 06:16 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to ignore the signs and make the functions work | Excel Worksheet Functions | |||
Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
nested if functions? | Excel Discussion (Misc queries) | |||
Nested functions HELP! | Excel Worksheet Functions | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |