Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weighted Averages in Excel
Hi,
I have four numbers in excel, each in a different cell. I need a fifth cell to show the average of the first four. No problem normally, but I need to give each figure a different weighting. So figures 1 & 2 must each be worth 17% of the average, figures 3 and 4 must each be worth 33% of the average. Can anyone tell me what formula I need to achieve this? Thanks Karl |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weighted Averages in Excel
=17%*(A1+B1)+33%*(C1+D1)
"Karl" wrote in message ... Hi, I have four numbers in excel, each in a different cell. I need a fifth cell to show the average of the first four. No problem normally, but I need to give each figure a different weighting. So figures 1 & 2 must each be worth 17% of the average, figures 3 and 4 must each be worth 33% of the average. Can anyone tell me what formula I need to achieve this? Thanks Karl |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weighted Averages in Excel
Thanks!
"Bob Umlas" wrote: =17%*(A1+B1)+33%*(C1+D1) "Karl" wrote in message ... Hi, I have four numbers in excel, each in a different cell. I need a fifth cell to show the average of the first four. No problem normally, but I need to give each figure a different weighting. So figures 1 & 2 must each be worth 17% of the average, figures 3 and 4 must each be worth 33% of the average. Can anyone tell me what formula I need to achieve this? Thanks Karl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
how do i set up a weighted factor model in excel? | Excel Worksheet Functions | |||
Moving averages in Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |