| 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)))))))) |
| 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 | |||
Threaded Mode
