How to Use Excel PERCENTILE Function in Office 365? – (with Examples)

Excel PERCENTILE Function:

PERCENTILE Function

In this article, we are going to see how to use the Excel PERCENTILE Function in Office 365 with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

PERCENTILE Function – Description:

• This function returns the K^th percentile of the given set of data.
• The percentile is a value below which a given percentage of values will be taken.
• You can use the percentile to find the 90^th percentile, 80^th percentile, and so on.

Syntax:

=PERCENTILE(array, k)

Arguments Explanation:

*Array – * It is the input array or range of data.

K – ** This is the number that represents the **k^th percentile. It should be in the range from 0 to 1.

Note:

• If k is less than 0 or greater than 1 and then this function returns #NUM! Error.
• K must be given as a decimal value that lies between 0 and 1 or a percentage (30%).
• If K is non-numeric values such as letters and symbols and then this function returns #VALUE! Error.
• If k is not a multiple of 1/(n-1), PERCENTILE will insert to determine the value at the k^th percentile.

Examples:

Let’s see some examples to understand how the PERCENTILE function will work.

Example 1:

• In the below screenshot, you can be able to see the input range in Column B , and it’s K^th values are given in Column D.
• The output is displayed in Column E.

Example 1

Example 2:

• If k is less than 0 or greater than 1 and then this function returns #NUM! Error.

Example 2

Example 3:

• If K is non-numeric values such as letters and symbols and then this function returns #VALUE! Error.

Example 3

From the above examples, you can clearly understand how to use PERCENTILE Function.

Conclusion:

In this article, you can understand the usage of Excel PERCENTILE Function in Office 365 with its syntax, explanation, and examples. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

Similar Functions:

• PERCENTILE.EXC Function
• PERCENTILE.INC Function

See Also:

• How to Use Excel STDEVP Function in Office 365? – [with Examples]
• How to Use Excel COMBIN Function in Office 365? – [with Examples]