#N/A
Thanks guys!!!!!!
"Jim Thomlinson" wrote:
There is a function called ISNA which you could use like...
=IF(isna(C81), "0", C81)
--
HTH...
Jim Thomlinson
"sixthhole" wrote:
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.
|