The limit is 8 nested functions in Excel 2003 and earlier, 64 in Excel 2007.
If you need more than 8, there might be a more efficient and manageable way
to write the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Afsha" wrote in message
...
Is there a maximum number of IF(AND's i can use in a formula or can it be
as
many as required?