Average
=(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.
|