Max number of IF statements
 

What is the max number of If statements you can use in a formula ?
Thanks,
yosef

7 embedded IFs, which means you can have the word IF a total of 8 times.
************
Anne Troy
www.OfficeArticles.com

"ynissel" wrote in message
...
What is the max number of If statements you can use in a formula ?
Thanks,
yosef

You can have 8 maximum nested if statements in 1.
--
Regards,

Dave


"ynissel" wrote:

What is the max number of If statements you can use in a formula ?
Thanks,
yosef

You can have dozens of IF() statements, but they can only be nested 7
deep. For a workaround, see

http://cpearson.com/excel/nested.htm

OTOH, if you have to nest more than 4 or 5 deep, it's almost always
easier to use an alternative method, e.g., Lookups, math operations, etc.


In article ,
"ynissel" wrote:

What is the max number of If statements you can use in a formula ?
Thanks,
yosef