software

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 amp; 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=17%*(A1 B1) 33%*(C1 D1)

quot;Karlquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have four numbers in excel, each in a different cell. I need a fifth
gt; cell
gt; to show the average of the first four.
gt;
gt; No problem normally, but I need to give each figure a different weighting.
gt; So figures 1 amp; 2 must each be worth 17% of the average, figures 3 and 4
gt; must
gt; each be worth 33% of the average.
gt;
gt; Can anyone tell me what formula I need to achieve this?
gt;
gt; Thanks
gt;
gt; Karl
gt;
Thanks!

quot;Bob Umlasquot; wrote:

gt; =17%*(A1 B1) 33%*(C1 D1)
gt;
gt; quot;Karlquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; I have four numbers in excel, each in a different cell. I need a fifth
gt; gt; cell
gt; gt; to show the average of the first four.
gt; gt;
gt; gt; No problem normally, but I need to give each figure a different weighting.
gt; gt; So figures 1 amp; 2 must each be worth 17% of the average, figures 3 and 4
gt; gt; must
gt; gt; each be worth 33% of the average.
gt; gt;
gt; gt; Can anyone tell me what formula I need to achieve this?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Karl
gt; gt;
gt;
gt;
gt;