I have numerious calculations occuring in cells. Many times if certain values
cannot be calculted, #N/A appears. I would like the field to display "Null"
or "Nothing" if the error appears. How can this be done? I want a different
display instead of #N/A.

One way:

Assuming your original formula is something like:

=VLOOKUP(A1,J:K,2,FALSE)

you can trap the error:

=IF(ISNA(MATCH(A1,J:J,FALSE)),"Nothing",VLOOKUP(A1,J:K,2,FALSE))

In article <89163499-477A-40AC-9901-(E-Mail Removed)>,
BZeyger <(E-Mail Removed)> wrote:

> I have numerious calculations occuring in cells. Many times if certain values
> cannot be calculted, #N/A appears. I would like the field to display "Null"
> or "Nothing" if the error appears. How can this be done? I want a different
> display instead of #N/A.

Add the ISNA function.

e.g.

=IF(ISNA(VLOOKUP(H9,$C$2:$F$35,3,FALSE)),"",VLOOKUP(H9,$C$2:$F$35,3,FALSE))

Will return a blank looking cell if result is #N/A

For "Null" type Null between the double quotes in formula


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 14:56:02 -0700, BZeyger <(E-Mail Removed)>
wrote:

>I have numerious calculations occuring in cells. Many times if certain values
>cannot be calculted, #N/A appears. I would like the field to display "Null"
>or "Nothing" if the error appears. How can this be done? I want a different
>display instead of #N/A.

On Oct 17, 5:56 pm, BZeyger <BZey...@discussions.microsoft.com> wrote:
> I have numerious calculations occuring in cells. Many times if certain values
> cannot be calculted, #N/A appears. I would like the field to display "Null"
> or "Nothing" if the error appears. How can this be done? I want a different
> display instead of #N/A.

=IF(ISNA(yourCalculation),"",yourCalculation)
or
=IF(ISNA(yourCalculation),"Null",yourCalculation)