| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attempting to weight
I am using the below formula to get a weighted sco
=(D2*C2)+(D3*C3)+(D4*C4)+(D5*C5)/J2 The scores in my spreadsheet are in column D and are percentages. These scores range from 0% - 100%. I need to weight these against the numbers in column C which represent the number received. I than divided by J2 which contains the sum of the numbers in column C. The issue is the formula is returning weighted scores like 2515.11%. I am totally lost on this one. Any assistance is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to limit the Weight of any weight distribution | Excel Discussion (Misc queries) | |||
| how to limit the Weight of any weight distribution | Excel Worksheet Functions | |||
| I am attempting to create a summary sheet | Excel Discussion (Misc queries) | |||
| Weight loss line chart to monitor weight loss progress | Charts and Charting in Excel | |||
| Attempting Excel Template | New Users to Excel | |||
Threaded Mode
