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.

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.

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.