| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#DIV/0! Error
Hi
I get an error (#DIV/0!) when I divide one cell by the other and there are no entries in the cells. How can i get the folrmula to surpress the error (show a blank cell) when there are no entries in the cells that the formula refers to? Could you please provide an example Thanks John |
|
#2
|
|||
|
|||
|
=IF(B1=0,"",A1/B1)
-- HTH Bob Phillips "Joohn Calder" wrote in message ... Hi I get an error (#DIV/0!) when I divide one cell by the other and there are no entries in the cells. How can i get the folrmula to surpress the error (show a blank cell) when there are no entries in the cells that the formula refers to? Could you please provide an example Thanks John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Div/0 error | Excel Worksheet Functions | |||
| Can I prevent a #DIV/0! error from plotting on a chart | Charts and Charting in Excel | |||
| DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
| # DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
| "Average" with error DIV/0 | Excel Discussion (Misc queries) | |||
Linear Mode
