Need command line to change the results in a cell from #DIV/0 to 0

  • Thread starter Thread starter mulehead
  • Start date Start date
M

mulehead

What would be a command line to change the results in a cell from #DIV/0 to
zero?
 
hi
command line???
a formula would work better.
you are dividing some cell by another cell that has a zero value. lets say
the first cell is a1 and the second is b1.
in a1..
=if(b1=0,0,A1/B1)

this way if b1 is zero the math will not take place. if it is not zero, the
formula will calculate.

Regards
FSt1
 
hi
sorry, that should be put the if formula in C1. my mistake.

Regards
FSt1
 
Unfortunately, I am trying to reverse engineer something, so I need a macro
command that will change #DIV/0 to 0 in all cells with #DIV/0, basically I
need to treat the symptom instead of treating the problem. Thanks for your
help.
 
You must log in or register to reply here.

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 "#DIV/0!" into a "0" (zero) 1
Help, need macro command that will change #DIV/0 to 0 1
When dividing by 0 can i show a result of 0 instead of #DIV/0 7
#DIV/0! error 1
#div/0 error 2
Find Average w/ #DIV/0! in Cell 5
Div / 0 5
I want to see blank cell rather to see #DIV/0! 4

Back
Top