Thread
:
MS Excel Nested Functions
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
external usenet poster
Posts: 3,440
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))))))))
|
|
|
Reply With Quote
Niek Otten
View Public Profile
Find all posts by Niek Otten