Logical Testing

A

Afsha

How many times can I use the IF AND combination ina formula, is there a
maximum?

thanks!
 
D

David Biddulph

In Excel 2003 you're limited to 7 levels of nesting of functions (whether IF
or other functions). In Excel 2007 this goes up from 7 to 64.
 
A

Afsha

because I could not see the first post for some reason - I thought the
subject might have filtered the question out???

can you see the first?
 
A

Afsha

OK this makes sense - I am in 2003 version and have more than 7 levels of
nesting!!!

many thanks
Afsha
 
Top