| 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 |
| 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 | |||
Threaded Mode
