MS Excel Nested Functions
 

Hello,

I want to nest more than 7 nested functions (actually I woould like to do
about 14 or more. Is this possible?

I have listed a sample of what I have to date but cannot seem to get any
more. Can you help?

=IF($C$11<=10000,C24,IF($C$11<20001,D24,IF($C$11<3 5001,E24,IF($C$11<50001,F24,IF($C$11<75001,G24,IF( $C$11<100001,H24,IF($C$11<150000,I24,IF($C$111499 9,J24))))))))

MS Excel Nested Functions
 

Use the VLOOKUP function instead.; unlimited and much easier to write and extend

Look here for a tutorial:

http://www.contextures.com/xlFunctions02.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aussie Barbie" <Aussie wrote in message
...
| Hello,
|
| I want to nest more than 7 nested functions (actually I woould like to do
| about 14 or more. Is this possible?
|
| I have listed a sample of what I have to date but cannot seem to get any
| more. Can you help?
|
|
=IF($C$11<=10000,C24,IF($C$11<20001,D24,IF($C$11<3 5001,E24,IF($C$11<50001,F24,IF($C$11<75001,G24,IF( $C$11<100001,H24,IF($C$11<150000,I24,IF($C$111499 9,J24))))))))
|
|
|

MS Excel Nested Functions
 

=INDEX(C24:K24,MATCH(C11,{0,10000,20000,35000,5000 0,75000,100000,150000},1))

you should be able to see where to increase this

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Aussie Barbie" <Aussie wrote in message
...
Hello,

I want to nest more than 7 nested functions (actually I woould like to do
about 14 or more. Is this possible?

I have listed a sample of what I have to date but cannot seem to get any
more. Can you help?

=IF($C$11<=10000,C24,IF($C$11<20001,D24,IF($C$11<3 5001,E24,IF($C$11<50001,F24,IF($C$11<75001,G24,IF( $C$11<100001,H24,IF($C$11<150000,I24,IF($C$111499 9,J24))))))))

MS Excel Nested Functions
 

Use a VLOOKUP() table rather than a nested IF
--
Gary''s Student - gsnu200765


"Aussie Barbie" wrote:

Hello,

I want to nest more than 7 nested functions (actually I woould like to do
about 14 or more. Is this possible?

I have listed a sample of what I have to date but cannot seem to get any
more. Can you help?

=IF($C$11<=10000,C24,IF($C$11<20001,D24,IF($C$11<3 5001,E24,IF($C$11<50001,F24,IF($C$11<75001,G24,IF( $C$11<100001,H24,IF($C$11<150000,I24,IF($C$111499 9,J24))))))))

MS Excel Nested Functions
 

Thanks heaps for all of your suggestions & assistance.

A big special thanks to Bob Phillips who had the solution solved in one go!
You're an Excel legend!!!

Aussie Barbie


"Bob Phillips" wrote:

=INDEX(C24:K24,MATCH(C11,{0,10000,20000,35000,5000 0,75000,100000,150000},1))

you should be able to see where to increase this

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Aussie Barbie" <Aussie wrote in message
...
Hello,

I want to nest more than 7 nested functions (actually I woould like to do
about 14 or more. Is this possible?

I have listed a sample of what I have to date but cannot seem to get any
more. Can you help?

=IF($C$11<=10000,C24,IF($C$11<20001,D24,IF($C$11<3 5001,E24,IF($C$11<50001,F24,IF($C$11<75001,G24,IF( $C$11<100001,H24,IF($C$11<150000,I24,IF($C$111499 9,J24))))))))