Logical Testing
 

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

thanks!

Logical Testing
 

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!

Logical Testing
 

On Jun 26, 10:33 am, Afsha wrote:
How many times can I use the IF AND combination ina formula, is there a
maximum?

thanks!

Why did you post this twice?

Logical Testing
 

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?

"Tim Shnell" wrote:

On Jun 26, 10:33 am, Afsha wrote:
How many times can I use the IF AND combination ina formula, is there a
maximum?

thanks!

Why did you post this twice?

Logical Testing
 

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!