Referencing a cell that returns "N/A"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on a spreadsheet where one cell is linked to another worksheet. The cells on other worksheet either have a number value, or they have a the "N/A" value. Is there anyway to say IF H6 ="#N/A", return the number 0? I have tried doing this but I only get "N/A" back. Could someone please help me
Thanks!
 
You can use either ISNA or ISERROR, like this:

=IF(ISNA('SheetName'!A2),0,'SheetName'!A2)

ISERROR will return zero regardless of the error. ISNA
will still return an error if the error is something other
than #N/A, but will return zero if it is #N/A.

tod
-----Original Message-----
I'm working on a spreadsheet where one cell is linked to
Click to expand...
another worksheet. The cells on other worksheet either
have a number value, or they have a the "N/A" value. Is
there anyway to say IF H6 ="#N/A", return the number 0? I
have tried doing this but I only get "N/A" back. Could
someone please help me?
 
Try

=IF(ISNA(H6),0,A1)



--

Regards,

Peo Sjoblom

Jman8180 said:
I'm working on a spreadsheet where one cell is linked to another
Click to expand...
worksheet. The cells on other worksheet either have a number value, or they
have a the "N/A" value. Is there anyway to say IF H6 ="#N/A", return the
number 0? I have tried doing this but I only get "N/A" back. Could someone
please help me?
 
Back
Top