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

M

Max

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

Mail Merge Switch - Dollars to Words 0
Need command line to change the results in a cell from #DIV/0 to 0 4
#DIV/0! displayed in Pivot Tables 0
#DIV?0! in Pivot Table 0
Help, need macro command that will change #DIV/0 to 0 1
#div/0 error 2
Div / 0 6
Getting "N/A" 2

Top