Percentile function.

PERCENTILE(p,range) computes pth percentile of the contents of the cells in the specified range. If one of the cells in range does not have a numeric value, but is empty or has a string value, then this cell will not be taken into account for calculating the percentile, or any of the other statistical functions.


PERCENTILE(75,A1:A100) returns the 75th percentile of the data in cells A1 to A100.

Related functions

This site uses cookies to store information on your computer. More info...