Thread: #DIV/0!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Martin Fishlock Martin Fishlock is offline
external usenet poster
 
Posts: 694
Default #DIV/0!

Hi Jim,
Say, a2=10 and a3=0.
You are trying to divide a number by 0 is in in cell a1 =a2/a3.

you can solve it by making sure that you do not divide by zero or if you do
not know if it will be zero try the following:

in cell a1 =if(a3=0,0,a2/a3) and this will put a 0 in place of the #div/0.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Jim S" wrote:

What does #DIV/0! mean when it shows up in a cell with a formula?

--
Jim S