Use both ISNA and ISERROR in a long formula

[dbsavoy]

I am working in Excel 2003 with a formula which has one ISERR and a total of
six vlookups. I am trying to have one cell look up values from other
worksheets and perform basic math on those values. In some instances I get
either #DIV/0! or #N/A!.

When I try to use both IF(ISNA) and IF(ISERR), an error message states that
my formula is too long. Is this because of the number of characters I am
typing into the cell or that I am trying to use more than 7 "formulas"? I
didn't think vlookups counted in that regard.

Is there any way to use both ISNA and ISERR at the same time? Something like:
IF(ISNA or ISERR ???
That would be just perfect...

 

[Niek Otten]

Post your formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am working in Excel 2003 with a formula which has one ISERR and a total of
| six vlookups. I am trying to have one cell look up values from other
| worksheets and perform basic math on those values. In some instances I get
| either #DIV/0! or #N/A!.
|
| When I try to use both IF(ISNA) and IF(ISERR), an error message states that
| my formula is too long. Is this because of the number of characters I am
| typing into the cell or that I am trying to use more than 7 "formulas"? I
| didn't think vlookups counted in that regard.
|
| Is there any way to use both ISNA and ISERR at the same time? Something like:
| IF(ISNA or ISERR ???
| That would be just perfect...

 

[Chip Pearson]

Formulas are limited to about 1K character length. Are your formulas that
long? You are limited in Excel 2003 and early to 7 levels of nesting. You're
probably at that limit, not the formula length limit.


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