| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| Sum To Work Out Targets | Excel Discussion (Misc queries) | |||
| Weight loss line chart to monitor weight loss progress | Charts and Charting in Excel | |||
| produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions | |||
| Delete Select Targets | Excel Discussion (Misc queries) | |||
Linear Mode
