Thread: Formula for average with a "IF" statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
latripl latripl is offline
external usenet poster
  
Posts: 1
Default Formula for average with a "IF" statement
I am trying to do a formula for averaging a series of numbers (which I can
do) exept if there is zero in the series I want to ignore it in the avg. How
do I write an IF statement for this?

Reply With QuoteReply With Quote