View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EBnLP01 EBnLP01 is offline
external usenet poster
 
Posts: 8
Default 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.