worksheet functions >> Use both ISNA and ISERROR in a long formula
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...
worksheet functions >> Use both ISNA and ISERROR in a long formula
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...
worksheet functions >> Use both ISNA and ISERROR in a long formula
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)
>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...