#N/A

[sixthhole]

Is there anyway to return "0" when a cell receives the #N/A error? Not in
the same cell, but another one so it can be used in a new formula.

Ex: =IF(C81="#N/A", "0")

This didn't work.

Thanks for any help I can get.

 

[Jon Peltier]

=IF(ISNA(C81),0,C81)

- Jon

 

[Jim Thomlinson]

There is a function called ISNA which you could use like...

=IF(isna(C81), "0", C81)

 

[sixthhole]

Thanks guys!!!!!!

There is a function called ISNA which you could use like...

=IF(isna(C81), "0", C81)

 

[Jon Peltier]

In your second post, you put the quotes back into my formula!

- Jon