| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! to read as 0
Is there a simple formula for displaying "0" as a result, not "#DIV/0!", when
cells are intentionally left blank or contain "0" as a divisor ? If so, how is it applied with a formula already in the cell? Hope someone's got the answer.. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with dividing and using ISERROR for Div/0! | Excel Worksheet Functions | |||
| How to hide #DIV/0! in cells waiting for input? | Excel Discussion (Misc queries) | |||
| remove read only - not showing up in properties | Excel Worksheet Functions | |||
| Send Excel File As Read Only | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
