Returns the rank of a value in a data set as a percentage of the data set.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
PERCENTRANK(array, x, [significance])The PERCENTRANK function calculates the relative standing of a value within a data set. It is useful for evaluating the relative position of a specific data point compared to the rest of the array.
=PERCENTRANK({1, 2, 3, 4, 5}, 3)Результат: 0.5
The value 3 is exactly in the middle of the set, representing the 50th percentile.
PERCENTRANK is included for compatibility with older versions; PERCENTRANK.INC is the modern equivalent that includes the bounds of the array.