View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newby1273 newby1273 is offline
external usenet poster
 
Posts: 5
Default Too many nested functions problem

I need to do this
=IF(IFH6=0,0,(H6<=13,13.1,IF(H6<=32,14.13,IF(H6<=5 2,14.99,IF(H6<=70,16.16,IF(H6<=90,16.74,IF(H6<=100 ,19.67,IF(H6<=200,39.34,IF(H6<=300,59.01,FALSE)))) )))))
but since it's more than 7 nested functions excel won't allow it. How can I
make this work?