How to Use Excel to Find Percentiles

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Excel to Find Percentiles
Excel can compute percentiles from a range of cells. (per cent image by Soja Andrzej from

Excel isn't just for entering information into spreadsheets -- it can be used to calculate a number of different mathematical formulas and functions, including finding percentiles. The Excel function used to calculate percentages is the percentile function, which has the formula "=percentile(RANGE,K)" where RANGE is a range of cells in the Excel spreadsheet and K is a percentile between 0 and 1. For example, the percentile function "=percentile(B1:B5,.25)" calculates the 25th percentile for the values in cells B1 to B5.

Skill level:


  1. 1

    Click on a blank cell in the worksheet with your pre-filled in values (the values for which you would like to find a percentile).

  2. 2

    Type "=percentile(."

  3. 3

    Type a range of cells. For example, if the numbers that you want to find a percentile for are located in cells A1 to A10, type "A1:A10."

  4. 4

    Type a comma followed by the percentile you want to find. This must be in decimal form. For example, instead of typing "90%," type ".9."

  5. 5

    Type a closing parenthesis ")" and then press the "Enter" key.

Don't Miss


  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.