PERCENTILE (PQL - xl)

This function returns the nth percentile of values in a range

Syntax

PERCENTILE(array, k)
Function Arguments

Name

Description

Type

Optional

array

Array of values representing the data

StringOrNumber

k

Value representing the percentile value between 0 and 1

Number

Comments

This function is the same as the Microsoft Excel 'PERCENTILE' function - using the same inputs, logic and outputs.