Thread: IF Statement calculating Average if you have numeric & text respon
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mellermj mellermj is offline
external usenet poster
  
Posts: 4
Default IF Statement calculating Average if you have numeric & text respon
I have a worksheet that tracks responses by month for each quarter. What is
the best way to set up an equation that will calculate the average if the
responses can either be a percentage or Yes or No response?
Reply With QuoteReply With Quote