Weight three different targets to produce an overall target.
 

I have a mind blank. I have three different percentage to target results and
these have to collate into a final percentage.

I need to weight these in a 40%, 35% and 25% manner towards the final target.

Weight three different targets to produce an overall target.
 

If %s are in A1:A3 and targets in B1:B3

=SUMPRODUCT(A1:A3,B1:B3)

"fishy" wrote:

I have a mind blank. I have three different percentage to target results and
these have to collate into a final percentage.

I need to weight these in a 40%, 35% and 25% manner towards the final target.

Weight three different targets to produce an overall target.
 

Hi,

I have 6 columns that have individual staff rows of the following data:
Lend Amount, LendingTarget, % to lending target, Income Fee, Incometarget, %
to income target
£1,000.00, £65,132.00, 1.54% £400.00 £2,220.00, 18.02%

I need to give them an overall rating. As you can see, the measures are
completely unrelated.

"Toppers" wrote:

If %s are in A1:A3 and targets in B1:B3

=SUMPRODUCT(A1:A3,B1:B3)

"fishy" wrote:

I have a mind blank. I have three different percentage to target results and
these have to collate into a final percentage.

I need to weight these in a 40%, 35% and 25% manner towards the final target.