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