PERCENTILE
Statistical

Returns the k-th percentile of values in a range

Syntax:

=PERCENTILE(array, k)

Example:

=PERCENTILE(A1:A100, 0.75)