0 divided by 0

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

In a formula if you divide 0 by 0 you get #DIV/01!

Is there any way to get 0 as an answer.
 
Frank

With two 0s in A3 and A4

=IF(ISERR(A3/A4),0,A3/A4)

Produces a 0. It says if dividing A3 by A4 = an error (anything except
#N/A), then put 0, if not do the calculation
 
With two 0s in A3 and A4

=IF(ISERR(A3/A4),0,A3/A4)

Produces a 0. It says if dividing A3 by A4 = an error (anything except
#N/A), then put 0, if not do the calculation
Click to expand...

It's generally not a good idea to use ISERR or ISERROR. It's useful to let most
errors pass through, such as #REF! or #NAME? errors which are signals that
something's going seriously wrong. Catching division by zero generally is best
dealt with by checking the denominator.
 
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

Div 0 help 1
When dividing by 0 can i show a result of 0 instead of #DIV/0 7
dividing 0 by 0 in excel 2003 10
working out % of correctness gives #DIV/0! 2
Average time 1
divide by zero error 5
iserror problem 9
REALLY NEED HELP ON THIS ONE. 5

Back
Top