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

  • Thread starter Thread starter mulehead
  • Start date Start date
One way is to trap for the denominator being blank/containing a zero,
eg: =IF(OR(B1="",B1=0),0,A1/B1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need command line to change the results in a cell from #DIV/0 to 0 4
#DIV/0! error 1
Help, need macro command that will change #DIV/0 to 0 1
I want to see blank cell rather to see #DIV/0! 4
#DIV/0! 3
#div/0 error 2
Zeros and #DIV/0! 5
#DIV/O! help to show zero. 2

Back
Top