Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way of not displaying 'Div0!' in a cell?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IRR & #DIV0! | Excel Worksheet Functions | |||
I WANT TO HIDE THIS #DIV0! | Excel Discussion (Misc queries) | |||
A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
#DIV0/! issues | Excel Discussion (Misc queries) | |||
Excel - IF Formula and #DIV0! | Excel Worksheet Functions |