View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Drewfus Drewfus is offline
external usenet poster
 
Posts: 1
Default 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.