Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)))))))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)))))))) | | | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)))))))) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)))))))) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)))))))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
too many nested IF functions | Excel Worksheet Functions | |||
Nested Functions with OR | Excel Worksheet Functions | |||
nested if functions in Excel 2002 | Excel Worksheet Functions | |||
ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions | |||
Too many nested functions | Excel Worksheet Functions |