Referencing a cell that returns "N/A"

[Jman8180]

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!

 

[Frank Kabel]

Hi
try
=IF(ISNA(H6),0,H6)
Frank

 

[Tod]

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

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?

 

[Peo Sjoblom]

Try

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



--

Regards,

Peo Sjoblom

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?