How do I weight numbers when some are zero without getting DIV0
 

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.

How do I weight numbers when some are zero without getting DIV0
 

If you want a useful reply, you're going to have to show a sample of your
data, and the formula your tired. Otherwise, we're just guessing.

Regards,
Fred.

"Drewfus" wrote in message
...
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.

How do I weight numbers when some are zero without getting DIV0
 

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.