Percentile Rank Excel Formula for HR Analytics, Boost your Analytical Skills

Looking to see where an employee’s pay ranks against existing salary ranges? Or want to calculate where a student’s grades rank against all others? The PercentRank formula in excel can do just that!

In this video I’ll go through an example of how to use the percent rank formula for compensation analysis, plus what you can do to make sense of this metric:

There is so much data analysis you can do with these quartiles and percentrank formulas! Stay tuned for the next video in this series where we’ll wrap it all up with a nice summary chart.

[penguinvsminja]

I am using Excel 2016 and the IFS function is not available, only IF. How would I set up the formula to tell me what quartile each employee is in. I have the top and bottom of each quartile defined for each salary range we have. I am just struggling to write the formula to tell me which quartile they are in. Thank you!