Return a value's percentile rank within a dataset.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
PERCENTRANK.INC(array, x, [significance])PERCENTRANK.INC converts a value into its relative standing between 0 and 1. It is useful when you need to show where a score, response time, or metric sits inside a distribution.
=PERCENTRANK.INC(A2:A100, B2)Result: 0.78
B2 is higher than about 78% of the dataset.
It means the value sits at the 78th percentile, higher than roughly 78% of the values in the range.