| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA
as above, what is the max number of "if" conditions available in one formula?
i cannot seem to add more than 8?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUM
Actually, there is no real limit on the number of IF functions in a single
formula. The limit is on the levels of nesting. Functions can be nested up to 7 levels deep in a formula. For example, the following formula far exceeds 8 IFs in a single formula, but still adheres to the limit of 7 levels of nesting. =IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",I F(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H","") )))))))&IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"K",IF(A 1=12,"L",IF(A1=13,"M",IF(A1=14,"N",IF(A1=15,"O",IF (A1=16,"P","")))))))) HTH, Elkar "Mike" wrote: It's seven Mike "gallie" wrote: as above, what is the max number of "if" conditions available in one formula? i cannot seem to add more than 8?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA
It's seven
Mike "gallie" wrote: as above, what is the max number of "if" conditions available in one formula? i cannot seem to add more than 8?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA | Excel Worksheet Functions | |||
| find/replace "cr" from end of number to "-" in front of number | Excel Discussion (Misc queries) | |||
| Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
