| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
division by zero error
I have a spreadsheet that divides one cell by another. The problem is
the cells do not always contain data. Is there any way to remove the #DIV/0! message that comes up? It does not look too professional. Thanks, Peter |
|
#2
|
|||
|
|||
|
Peter here is one way, instead of =A1/B1 you could use
=IF(ISERROR(A1/B1),"",A1/B1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "peter" wrote in message ups.com... I have a spreadsheet that divides one cell by another. The problem is the cells do not always contain data. Is there any way to remove the #DIV/0! message that comes up? It does not look too professional. Thanks, Peter |
|
#3
|
|||
|
|||
|
Thanks, Paul!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
| Findlink Error | Links and Linking in Excel | |||
| Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
| Excel Progrom Error | Excel Discussion (Misc queries) | |||
| Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) | |||
Linear Mode
