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

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

Maybe one way:

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

Regards,
Paul

--

"Rani" wrote in message
...

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

On Mon, 6 Aug 2007 09:50:05 -0700, Rani wrote:

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

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

In Excel 2007, perhaps:

=IFERROR(3.14/A1,"")

Returns blank if A1 evaluates to zero.

--
Dana DeLouis
Windows XP & Excel 2007


"Rani" wrote in message
...

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

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).
--
David Biddulph

"Dana DeLouis" wrote in message
...
In Excel 2007, perhaps:

=IFERROR(3.14/A1,"")

Returns blank if A1 evaluates to zero.

"Rani" wrote in message
...