ExcelBanter - divide by zero

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - divide by zero (https://www.excelbanter.com/excel-worksheet-functions/82255-divide-zero.html)

chiuinggum

divide by zero

anything that is divide by zero will get #DIV/0!. how can I show the result
ias zero insted?

PY & Associates

divide by zero

=IF(B1=0, 0,A1/B1)

"chiuinggum" wrote in message
...
anything that is divide by zero will get #DIV/0!. how can I show the
result
ias zero insted?

All times are GMT +1. The time now is 07:26 PM.