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

  • Thread starter Thread starter Drewfus
  • Start date Start date
D

Drewfus

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.
 
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.
 
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
 
Back
Top