Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Formula Help
I need a formula to provide the perfect score in a catagory Using a relative index of 5 and weights Category-Performance Relativity Index-5 Weights-as noted below Scope Of Work-8 (weight) Service Level-6 (weight) Estimate Turn Time-8 (weight) Timeliness of Repairs-8 (weight) Ingate To Available-6 (weight) Inventory Reporting-4 (weight) Staus Response-8 (weight) Sub-total (perfect score) 137 (is this correct) What should the formula be for this? needinhelp -- needinhelp ------------------------------------------------------------------------ needinhelp's Profile: http://www.excelforum.com/member.php...o&userid=32173 View this thread: http://www.excelforum.com/showthread...hreadid=519203 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Formula Help
You have to understand that you are the only one who has any idea whatsoever
what you are talking about. Please provide details about your data layout (this is in that column, that is in this other column, etc). Tell us in what column you want this formula. Then tell us exactly how you would go about calculating the answer if you were doing it manually. HTH Otto "needinhelp" wrote in message ... I need a formula to provide the perfect score in a catagory Using a relative index of 5 and weights Category-Performance Relativity Index-5 Weights-as noted below Scope Of Work-8 (weight) Service Level-6 (weight) Estimate Turn Time-8 (weight) Timeliness of Repairs-8 (weight) Ingate To Available-6 (weight) Inventory Reporting-4 (weight) Staus Response-8 (weight) Sub-total (perfect score) 137 (is this correct) What should the formula be for this? needinhelp -- needinhelp ------------------------------------------------------------------------ needinhelp's Profile: http://www.excelforum.com/member.php...o&userid=32173 View this thread: http://www.excelforum.com/showthread...hreadid=519203 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |