View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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.