Thread: Calculating weighted averages
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Calculating weighted averages
The formula for weighted average in this case is:
=(200000*5+1000000*4.5)/(200000+1000000)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote