#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
|