Divide by Zero

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

How Can I get rid of/avoid Divide by 0 Errors?

Somestimes it's unavoidable.

Thanks
Steve
 
Steve said:
How Can I get rid of/avoid Divide by 0 Errors?

Somestimes it's unavoidable.
Click to expand...

If Bottom = 0 or IsNull(Bottom) then

msgbox "you can't divide by zero"
else
ans = top/bottom.

end if.

This is a crude solution

While I can think of a few cases where it might cause a problem, usually it
can be avoided with proper design.
 
If you know that the divisor in a calculation may, under some
circumstances, be zero, you must explicitly test for that possibility
befoe you perform the calculation.

How Can I get rid of/avoid Divide by 0 Errors?

Somestimes it's unavoidable.

Thanks
Steve
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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

Dividing by Zero in Access Reports 14
Divide by the minimum non-zero number in a range of cells 21
Divide by zero error 3
Adjusting Dividing Line 3
Adding value of ComboA and ComboB then dividing by 2 3
Average Function 4
divide by zero error 5
division formula 2

Back
Top