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.
 

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
Average time 1
working out % of correctness gives #DIV/0! 2
iserror problem 9
divide by zero error 5
REALLY NEED HELP ON THIS ONE. 5

Back
Top