PERCENTILE.INC function

Category: Statistical
Introduced: Excel 2010

Summary

Returns the k-th percentile of values in a range

Syntax

PERCENTILE.INC(array,k) The PERCENTILE.INC function syntax has the following arguments:
• Array Required. The array or range of data that defines relative standing.
• K Required. The percentile value in the range 0 to 1, inclusive.

Example

=PERCENTILE.INC(A2:A5,0.3)

Microsoft Support Page

https://support.microsoft.com/en-us/office/percentile-inc-function-680f9539-45eb-410b-9a5e-c1355e5fe2ed

Back to Functions