Maverick01b
New Member
- Joined
- Jun 25, 2013
- Messages
- 3
Hello people who are smarter than I
I need a formula to rank a value 1-100, but then penalize any value that is above 100. Is is a "percent to budget" ranking, so going over budget can not help you rank the highest in the company. I would need the ranking to look something like this...
The 102 store would out-rank the 97 store because the 102 store is only 2 points away from the target goal number of 100%, where as the 97 store is 3 points away. Hopefully this makes sense.
Percent - Rank
100 - 1st
97 - 5th
99 - 2nd
101 - 2nd
102 - 4th
Help would be GREATLY appreciated!
-Mav
I need a formula to rank a value 1-100, but then penalize any value that is above 100. Is is a "percent to budget" ranking, so going over budget can not help you rank the highest in the company. I would need the ranking to look something like this...
The 102 store would out-rank the 97 store because the 102 store is only 2 points away from the target goal number of 100%, where as the 97 store is 3 points away. Hopefully this makes sense.
Percent - Rank
100 - 1st
97 - 5th
99 - 2nd
101 - 2nd
102 - 4th
Help would be GREATLY appreciated!
-Mav