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:
Other People Are Reading
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).
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."
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."
Type a closing parenthesis ")" and then press the "Enter" key.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for