Too many nested functions problem

  • Thread starter Thread starter newby1273
  • Start date Start date
N

newby1273

I need to do this
=IF(IFH6=0,0,(H6<=13,13.1,IF(H6<=32,14.13,IF(H6<=52,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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Range maker code 9
Date and If problem 6
Problem with a function that calls itself 3
Nested IF Function problem for Excel 2003 7
Formula Array Macro 5
Is there an Excel Function that can be used in lieu of this formul 5
Overstrike problem 1
sporadic conditional formatting problem 6

Back
Top