#DIV/0!

[Hagar]

Ho can I make this (#DIV/0!) disappear when no values are used in the
formula, the results of which are displayed in this particular cell ??

TIA,

Hagen

 

[JE McGimpsey]

One way:

=IF(B1=0,"",A1/B1)

 

[Bob Umlas]

easiest way (because you don't need to change any formulas) - select the
cell (or all the cells which MAY contain this error)
and use Format/Conditional Formatting, change "cell value is" to "formula
is", and, assuming D2 is the active cell, for example, enter =ISERROR(D2),
then click the Format button, select a White font (or whatever the
background sheet color is), then OK your way out.
You can do this for the entire worksheet as well.
Bob Umlas
Excel MVP