Help with my pourcentage

Jchicoine · May 2nd, 2002, 02:04 PM

HI everybody ! Here's what I'm looking for :

I have many employees and once a year I do an evaluation for everyone. The scores are calculated in pourcentage and I must rank them in order to have :

5 % of them must have the rank "Super Performant"
20 % of them must have the rank "Very Performant"
60 % of them must have the rank "Performant"
10 % of them must have the rank "Less performant"
5 % of them must have the rank "Non performant"

I really don't know how to do it ! Please help me and thanks a lot !

JChicoine, Canada

waderw · May 2nd, 2002, 02:06 PM

Are you using VB code or looking for a formula?

Asala42 · May 2nd, 2002, 03:02 PM

Hey there,

If you're trying to do this via formulas, you will likely want to use the PERCENTRANK formula.

As an example, I'm guessing you have a column of names (say column A), a column of evaluation scores (say column B).

This formula will give each individual's rank (assuming high numeric scores = good):

=PERCENTRANK($B$2:$B:200,B2)

with this function, your top scorer would have a PercentRank of 100%, you lowest 0%

If you wanted to have the rank titles pull automatically, you could use this formula:

=IF(PERCENTRANK($B$2:$B:200,B2)>95%,"Super Performant",IF(PERCENTRANK($B$2:$B:200,B2)>75%,"Very Performant",IF(PERCENTRANK($B$2:$B:200,B2)>15%,"Performant",IF(PERCENTRANK($B$2:$B:200,B2)>5%,"Less Performant","Non Performant")))))

Hope that helps,
Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 02:04 PM	#1
Jchicoine New Member Join Date: Apr 2002 Posts: 22	HI everybody ! Here's what I'm looking for : I have many employees and once a year I do an evaluation for everyone. The scores are calculated in pourcentage and I must rank them in order to have : 5 % of them must have the rank "Super Performant" 20 % of them must have the rank "Very Performant" 60 % of them must have the rank "Performant" 10 % of them must have the rank "Less performant" 5 % of them must have the rank "Non performant" I really don't know how to do it ! Please help me and thanks a lot ! JChicoine, Canada

May 2nd, 2002, 02:06 PM	#2
waderw Board Regular Join Date: Apr 2002 Posts: 85	Are you using VB code or looking for a formula?

May 2nd, 2002, 03:02 PM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hey there, If you're trying to do this via formulas, you will likely want to use the PERCENTRANK formula. As an example, I'm guessing you have a column of names (say column A), a column of evaluation scores (say column B). This formula will give each individual's rank (assuming high numeric scores = good): =PERCENTRANK($B$2:$B:200,B2) with this function, your top scorer would have a PercentRank of 100%, you lowest 0% If you wanted to have the rank titles pull automatically, you could use this formula: =IF(PERCENTRANK($B$2:$B:200,B2)>95%,"Super Performant",IF(PERCENTRANK($B$2:$B:200,B2)>75%,"Very Performant",IF(PERCENTRANK($B$2:$B:200,B2)>15%,"Performant",IF(PERCENTRANK($B$2:$B:200,B2)>5%,"Less Performant","Non Performant"))))) Hope that helps, Adam