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) |