If statements

Hi Stephen. The maximum number is 7.

Hope this helps,

Anthony

Hi Stephen

The Pre-2007 Excel limit for nested IF statements was 7.

With Excel 2007 the limit has been raised to 64 nested IF statements.

Although the limit is so large, I feel from experience that if your Nested IF statement is over 7 then you need to reconsider the statement or find an easier way of looking for the data.

Regards

Carlos