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.
 
Back
Top