G
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PCLIVE
Maybe one way:
=if(iserror(<your formua>),"",<your formula again>)
Regards,
Paul
=if(iserror(<your formua>),"",<your formula again>)
Regards,
Paul
R
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
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
D
Dana DeLouis
In Excel 2007, perhaps:
=IFERROR(3.14/A1,"")
Returns blank if A1 evaluates to zero.
=IFERROR(3.14/A1,"")
Returns blank if A1 evaluates to zero.
D
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).
error.
It is usually safer to use a formula such as =IF(A1=0,"",3.14/A1).