Suppress #Value! errors

[www.ttdown.com]

Is there anyway to turn off errors like #Value! or #DIV/O in a
spreadsheet? I have a formula that works when there is data in a cell
that is referenced but when the cell is empty I get the #DIV/O error.
I'd like to suppress the error without using the =IF function. Just
thought maybe there might be some kind of setting that would disable
these types of error messages when I print the spreadsheet.

Thanks!!

 

[Anders S]

One way is to use Conditional Formatting, CF, with a formula like
=ISERROR(A1)
and format for white text when the condition is TRUE.

HTH
Anders Silvén