You can create a nested IF function so that if the cell you are dividing by
equals 0, then you can specific what is put into the cell with the function,
and if the cell being divided by doesn't equal 0, then perform the dividing...

Let's say C1 is B1 being divided by A1...
IF(A1=0,*,B1/A1)

where * is the value you want in the event that A1 is 0

--
-Zakhary


"Drewfus" wrote:

I am trying to weight handletimes over a period of days. I want to set up
the formula so that as more information is added it will update but I keep
getting DIV0 errors. I have tried multiple 'if' and 'iserror' statements but
they haven't worked or I end up with a number that is out of whack.