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

many thanks
Afsha

"David Biddulph" wrote:

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.
--
David Biddulph

"Afsha" wrote in message
...
How many times can I use the IF AND combination ina formula, is there a
maximum?

thanks!