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
|