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.