Custom Format for Hiding #DIV/0!

[Matt]

It's probably wishful thinking but I'm sure I've used it before - is there a custom format which I can apply to a cell to hide the #DIV/0 error?

thanks Matt

[wi_guy]

Not that I know of, but a simple test in the cell would solve it also........ IF numerator is in A, and denominator is in B, formula would be =IF(B1<>0,+A1/B1,"")

[Aladin Akyurek]

On 2002-03-28 08:34, Matt wrote:
It's probably wishful thinking but I'm sure I've used it before - is there a custom format which I can apply to a cell to hide the #DIV/0 error?

thanks Matt

Matt,

It's better to add control to formulas that lead to #DIV/0! as in:

=IF(B1,A1/B1,0)

instead of just:

=A1/B1

If you insist on formatting, use conditional formatting with the formula:

=ISERR(E2)

and select white a color on the Font tab.

Aladin

[Matt]

Thanks Guys

[Geronimo]

Here is an example of some formatting that I'm using currently:

=IF(ISBLANK(B32)," ",AVERAGE(B32:E32))

It does away with the #DIV/0 error text. Of course, replace my cell & range references with your own.

[ This Message was edited by: Geronimo on 2002-04-01 04:14 ]

[Aladin Akyurek]

On 2002-04-01 04:13, Geronimo wrote:
Here is an example of some formatting that I'm using currently:

=IF(ISBLANK(B32)," ",AVERAGE(B32:E32))

It does away with the #DIV/0 error text. Of course, replace my cell & range references with your own.

[ This Message was edited by: Geronimo on 2002-04-01 04:14 ]

Geronimo,

An alternative to your current way of avoiding the #DIV/0! error would be:

=SUM(B32:E32)/MAX(1,COUNT(B32:E32))

I notice that you return a space (i.e., " ") instead of a blank (i.e., "") or a zero.

The alternative above will return a zero. If you'd like not to see a zero, custom format the cell of the formula as:

0.0;-0.0;;@

or

[=0]"";General

Aladin