Suppress #Value! errors

  • Thread starter Thread starter www.ttdown.com
  • Start date Start date
W

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!!
 
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
 
Back
Top