If statements

Resolved · Low Priority · Version 2007

Wed 22 Apr 2009, 16:00 Delegate Stephen said...

Stephen has attended:
Excel Advanced course

If statements

what is the maimum number of nested if functions in 1 formula

Wed 22 Apr 2009, 16:38 Trainer Anthony said...

RE: If statements

Hi Stephen. The maximum number is 7.

Hope this helps,

Anthony

Wed 22 Apr 2009, 16:40 Trainer Carlos said...

RE: If statements

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