| Home |
| Search |
| Today's Posts |
|
#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 ... |
| 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 | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
