Either include an IF statement like
=IF(ISERROR(YourFunction),"",YourFunction)
or
=IF(ISNA(YourFunction),"",YourFunction)

or, if you truly want to delete them, you can use F5 - Special - Formulas -
Error, and then press delete (but I don't recommend this!)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Doug" wrote:

How can I make a cell blank when it has a certain phrase such as #DIV/0! or
N/A. I have a lot of these and it would be much better without them. I
prefer a blank cell. Any ideas out there?
--