Dividing zero by zero
By far the simplest way is to check if the cell contains zero
=IF(B1=0,"",A1/B1)
Mike
"Sanjeev Raghavan" wrote:
In my work sheet 2 column with numbers and in some columns both numbers are
zeros. Is there any forlume I can use in order to get zero as result not
#DIV/0!
Please advice.
Sanjeev
|