ExcelBanter - IF(AND( formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF(AND( formula (https://www.excelbanter.com/excel-discussion-misc-queries/148009-if-formula.html)

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

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?

Yes, there are limits, but it depends which version of Excel you have. There
are two limits that you'd need to be concerned with:

Length of formula. In Excel 2003 and earlier, a formula can only contain
1024 characters. In Excel 2007, the limit is increased to 8192 characters.

Levels of Nesting. In Excel 2003 and earlier, you may only nest (placing a
function inside of another function) up to 7 levels deep. In Excel 2007, the
limit is increased to 64 levels.

So, in answer to your question, there is no limit (other than total
characters) to how many IF(AND functions you can use. However, there is a
limit on how deep you can nest them inside of one another.

HTH,
Elkar

"Afsha" wrote:

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