  Get instant live expert help with Excel or Google Sheets “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

# Excel PERCENTILE.INC Function

The PERCENTILE.INC function in Excel takes a range and returns the k-th percentile of values. Here, k is a value between 0 and 1, inclusive. It is a great way to calculate percentile from a set of values. In this tutorial, we will learn how to use the PERCENTILE.INC function in Excel. Figure 1. Example of How to Use the Excel PERCENTILE.INC Function

A percentile is a comparison value between a certain value and the values of the rest of the data. For example, say you have scored 80 on a test, and in the 85th percentile. It means that the 80 is higher than 85 % of all other scores. Here, the value for k is 85% or .85.

## Syntax

`=PERCENTILE.INC (array, k)`

## Arguments

• Array – This argument is required. It is the range or set of data values.
• K – This argument is required as well. It is the number in the range 0..1 that represents the kth percentile.

## Setting Up Data

The following example contains a children’s information data set. Column A and B has the names and ages respectively. Column D has the K values. Figure 2. The Data Set

To find out the kth percentile in column E, we need to:

• Go to cell E2.
• Assign the formula `=PERCENTILE.INC(\$B\$2:\$B\$8, D2)` to E2.
• Press Enter. Figure 3. Applying the Formula

• Drag the formula from cells E2 to E5.

This will show the results in column E.

## Notes

1. PERCENTILE.INC returns a #NUM! error if the array is empty.
2. It returns a #VALUE! error if the value for k is non-numeric.
3. PERCENTILE.INC returns a #NUM! error if k is less than 0 or greater than 1.
4. PERCENTILE.INC determines the value at the k-th percentile by interpolation if k is not a multiple of 1/(n – 1).

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Solution examples I need a formula that has these 2 rules. If letter was rec'd between 1st and 15th = 1st of the month following letter rec'd date. If letter was rec'd between 16thst and end of the month= 1st of the 2nd month following letter rec'd date.
Solved by V. F. in 20 mins I need a column to total (Hours)(85) + (Travel)(.55) per line
Solved by F. Q. in 20 mins Trying to figure out what is wrong with my formula in Oct-ZD tab in column AY and BG.
Solved by O. Q. in 8 mins So I have used vlookup to find the price of a product on a different sheet and then I have tried to times that by a quantity. e.g. =vlookup(d4,table35,2,false)*e4 This is the formula I typed in which worked for another list I did but for some reason it's not working now even though everything is practically the same, apart from the contents. Could you help?
Solved by B. U. in 60 mins I have a column containing date and time data together and i need to isolate the time data. When I tried to use text to column, it changed all the times to AM. There is an extremely large amount of data - over 550,000 rows so manually changing it won't work. The file is too large to attach.
Solved by S. E. in 40 mins 