Use both ISNA and ISERROR in a long formula  
Author Message
laurieg





PostPosted: Tue Oct 23 13:33:03 PDT 2007 Top

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...

Excel227  
 
 
Niek





PostPosted: Tue Oct 23 13:33:03 PDT 2007 Top

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...


 
 
Chip





PostPosted: Tue Oct 23 14:45:06 PDT 2007 Top

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...