Thread: #DIV/0! error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dbconn dbconn is offline
external usenet poster
 
Posts: 16
Default #DIV/0! error

I have the following formula entered to compute the average of a range of
cells and discount zeros. Until I change one of the zeros to a number, I get
#DIV/0!, How do I get rid of this

My formula is: =AVERAGE(Q8:Q18,"<0",Q8:Q18)
--
dbconn