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

F

FSt1

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
 
M

mulehead

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.
 

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
When dividing by 0 can i show a result of 0 instead of #DIV/0 7
#DIV/0! error 1
#DIV/0! displayed in Pivot Tables 0
#div/0 error 2
#DIV?0! in Pivot Table 0
Help, need macro command that will change #DIV/0 to 0 1
Div / 0 6

Top