Hi - I'm racking my brains and not coming up with any decent solutions to a problem returning a performance rating for our team members.
I've attached an example workbook where I am trying to give each team meber a performance rating within a percentage split of 20/70/10
Is there a formula that can looking up if an team member is within the top 20% of scores and give them an AAA rating, 70% AA and 10% A
Any help will be much appreciated ! !
The PERCENTILE function is the one you want. Put this in E13, then copy down:
=IF(B13>=PERCENTILE($B$13:$B$57, 0.9), "AAA", IF(B13>=PERCENTILE($B$13:$B$57, 0.1), "AA", "A"))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Excellent, thanks for your help
=IF(B13>=PERCENTILE($B$13:$B$57, 0.9), "AAA", IF(B13>=PERCENTILE($B$13:$B$57, 0.1), "AA", "A"))
What is 0.9 or 0.1 Says?
I have same set of value in numbers not in decimal value... how to calculate?
Sowmitri,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks