Thread: getting rid of a #Div/0! error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
StephenAccountant StephenAccountant is offline
external usenet poster
  
Posts: 26
Default getting rid of a #Div/0! error
here is my formula - it is an array formula.

=AVERAGE(IF(D9:G9<0,D9:G9))

if the cells all show up as blank or nil - i get a #Div/0! error - how can I
stop that from happening?
Reply With QuoteReply With Quote