Thread: entering more than seven levels of functions with in a function
View Single Post
  #2  
Old June 3rd, 2010, 03:25 AM posted to microsoft.public.excel.worksheet.functions
Mike Middleton[_2_]
external usenet poster
  
Posts: 90
Default 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.