ExcelBanter - Need command line to change "#DIV/0!" into a "0" (zero)

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need command line to change "#DIV/0!" into a "0" (zero) (https://www.excelbanter.com/excel-discussion-misc-queries/188155-need-command-line-change-div-0-into-0-zero.html)

mulehead

Need command line to change "#DIV/0!" into a "0" (zero)

What would be a command line to change the results in a cell from #DIV/0 to
zero?

Max

Need command line to change "#DIV/0!" into a "0" (zero)

One way is to trap for the denominator being blank/containing a zero,
eg: =IF(OR(B1="",B1=0),0,A1/B1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mulehead" wrote:
What would be a command line to change the results in a cell from #DIV/0 to
zero?

All times are GMT +1. The time now is 04:21 AM.