Max amount of "IF" statements

E

EBnLP01

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.
 
K

Kassie

From Excel 2007 help

Nested levels of functions 64
--
HTH

Kassie

Replace xxx with hotmail
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
IF statement with 2 logicals 1
Conditional Format based upon if statement and max 11
IF statement not returning correct answer 3
Multiple IF statements, macro stops at first True 0
Alternative to nested if statement 0
SUMIFS, one criteria range, multiple criteria 2
Max function 13

Top