PERCENTILE Function

Returns the value of a given percentile in a range.
Sample Usage
PERCENTILE(Data:Data, .75)
Syntax
PERCENTILE(
  • range
  • percentile
)
  • range
    The group of cells to evaluate.
  • percentile
    A decimal number between 0 and 1 representing the percentile to return.