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?

Too many nested functions problem
 

Have a look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"newby1273" wrote in message
...
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?

Too many nested functions problem
 

I would suggest using:

=INDEX(B1:B9,IF(ISNUMBER(MATCH(H6,A1:A9,0)),MATCH( H6,A1:A9,0),1+MATCH(H6,A1:A9,1)))

where A1:B9 is your table of lookup values. This will produce your desired
results.

Alan

"newby1273" wrote:

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?