Thread: Average
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S Davis S Davis is offline
external usenet poster
 
Posts: 138
Default Average

This got a loud *hoot* out of me here in the office. Something about
the misposted reply + your signature :) Thanks for the laugh

Dave F wrote:
=(50,000*.2+40,000*.2+30,000*.6)/3

Dave
--
Brevity is the soul of wit.


"Jordan" wrote:

Can anyone tell me what formula to use to average something like this:

$50K - 20%
$40K - 20%
$30K - 60%

Where $50k has 20% of the weight, etc. Any help will be greatly appreciated.