| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max amount of "IF" statements
What is the max amount of "if" statements can you have in one cell using
Office '07? Why i ask this, is b/c i know that if you have more than 7 if statements in one cell, it will NOT work if someone is using a later version of excel. example, if you create something in office '07, and have more then 7 if statements within a cell, a person using office '03 can't open the file...it crashes on them. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Max amount of "IF" statements
From Excel 2007 help
Nested levels of functions 64 -- HTH Kassie Replace xxx with hotmail "EBnLP01" wrote: What is the max amount of "if" statements can you have in one cell using Office '07? Why i ask this, is b/c i know that if you have more than 7 if statements in one cell, it will NOT work if someone is using a later version of excel. example, if you create something in office '07, and have more then 7 if statements within a cell, a person using office '03 can't open the file...it crashes on them. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Max amount of "IF" statements
Thank you VERY much Kassie !!
"Kassie" wrote: From Excel 2007 help Nested levels of functions 64 -- HTH Kassie Replace xxx with hotmail "EBnLP01" wrote: What is the max amount of "if" statements can you have in one cell using Office '07? Why i ask this, is b/c i know that if you have more than 7 if statements in one cell, it will NOT work if someone is using a later version of excel. example, if you create something in office '07, and have more then 7 if statements within a cell, a person using office '03 can't open the file...it crashes on them. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Need more than 7 nested "IF" statements in Excel" | Excel Discussion (Misc queries) | |||
| 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
