| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many levels in the IF function?
I am trying to create an IF formula that I can later paste into data
validation. However to keep this question simple at first, I will ask it this way. Try this formula in a blank spread sheet, in cell B1: =IF(A1=1,M1,IF(A1=2,N1,IF(A1=3,O1,IF(A1=4,P1,IF(A1 =5,Q1,IF(A1=6,R1,IF(A1=7,S1,IF(A1=8,T1,0)))))))) That works but if you add another "level": =IF(A1=1,M1,IF(A1=2,N1,IF(A1=3,O1,IF(A1=4,P1,IF(A1 =5,Q1,IF(A1=6,R1,IF(A1=7,S1,IF(A1=8,T1,IF(A1=9,U1: U10,0))))))))) ....You get the following error: The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format. Can we change the file format? Is there another totally different method to achieve this? Do you have any remedy for this at all? Thanks for your consideration. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I increase nested function 'IF' in EXCEL upto 10 levels | Excel Worksheet Functions | |||
| What function do I use to summarize data levels on three sheets? | Excel Worksheet Functions | |||
| sum sub levels. | Excel Discussion (Misc queries) | |||
| How to setup a nested if function with 10 levels? | Excel Worksheet Functions | |||
| IF function with 14 nested levels | Excel Worksheet Functions | |||
Threaded Mode
