In your second post, you put the quotes back into my formula!
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Jon Peltier" wrote in message
...
=IF(ISNA(C81),0,C81)
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"sixthhole" wrote in message
...
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.