View Single Post
  #1   Report Post  
mrtoyz mrtoyz is offline
Junior Member
 
Posts: 3
Default 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