Is there a way of not displaying 'Div0!' in a cell?

[Guest]

 

[PCLIVE]

Maybe one way:

=if(iserror(<your formua>),"",<your formula again>)

Regards,
Paul

 

[Ron Rosenfeld]

There are many ways. To interpret literally what you write, one would use
Conditional Formatting


Select the cells that contain the error value.
On the Format menu, click Conditional Formatting.
In the box on the left, click Formula Is.

In the box on the right, type =ISERROR(reference), where reference is a
reference to the cell that contains the error value.
Click Format, and then click the Font tab.

Click Format.
In the Color box, select white (or whatever color matches the cell background).


Of course, that formula will hide every error.

If you just want to hide DIV/0 errors, try this formula instead:

=2=ERROR.TYPE(reference)
--ron

 

[Dana DeLouis]

In Excel 2007, perhaps:

=IFERROR(3.14/A1,"")

Returns blank if A1 evaluates to zero.

 

[David Biddulph]

But of course that doesn't distinguish between #DIV/0! and other forms of
error.
It is usually safer to use a formula such as =IF(A1=0,"",3.14/A1).