loading...

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

excelgeek profile image Andrews Originally published at geekexcel.com on ・3 min read

Excel PERCENTILE Function:

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 Kth 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 90th percentile, 80th 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 **kth 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 kth 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 Kth values are given in Column D.
  • The output is displayed in Column E.

Example 1
Example 1

Example 2:

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

Example 2
Example 2

Example 3:

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

Example 3
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:

Posted on by:

excelgeek profile

Andrews

@excelgeek

Founder of Geek Excel!! Blog for Excel Tutorials

Discussion

pic
Editor guide