| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering more than seven levels of functions with in a function
CAMPLI -
WHAT IS THE SOLUTION FOR THIS < VLOOKUP - Mike http://www.MikeMiddleton.com "CAMPLI" wrote in message ... I WANT TO PUT MORE THAN SEVEN LEVELS OF FUNCTIONS WITH A FUNCTION. FOR EXAMPLE =IF(B14=10000,14500,IF(B14=10470,15100,IF(B14=1094 0,15700,IF(B14=11410,16300,IF(B14=11880,16900,IF(B 14=12350,17500,IF(B14=12820,18100,IF(B14=13320,187 00,IF(B14=13820,19400,IF(B14=14320,20100,IF(B14=14 880,20900,IF(B14=15440,21700,IF(B14=16000,22500,IF (B14=16560,23300,IF(B14=17120,24100,IF(B14=17680,2 4900,IF(B14=18240,25700,IF(B14=18800,26500,IF(B14= 19360,27300,IF(B14=19920,28100,IF(B14=20480,28900, IF(B14=21040,29700,IF(B14=21660,30600,IF(B14=22280 ,31500,IF(B14=22900,32400,IF(B14=23520,33300,0)))) )))))))))) BUT EXCEL IS NOT ALLOWING ME TO PUT MORE THAN SEVEN FUNCTIONS IN A FUNCTION. THEN WHAT I SHOULD DO. WHAT IS THE SOLUTION FOR THIS. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too many levels in the IF function? | Excel Discussion (Misc queries) | |||
| Maxing out nesting levels limitation of IF function | Excel Worksheet Functions | |||
| What function do I use to summarize data levels on three sheets? | Excel Worksheet Functions | |||
| How to setup a nested if function with 10 levels? | Excel Worksheet Functions | |||
| IF function with 14 nested levels | Excel Worksheet Functions | |||
![Mike Middleton[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
