ExcelFlux

PERCENTRANK function

the percentage rank of a value in a data set.

Compatibility

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Check the inclusive endpoints of the legacy percentile ranking function.

A worked example from the workbook

RowA
6Trial
710
820
930
Record 1
=PERCENTRANK($A$7:$A$9,A7)

Expected result0

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=PERCENTRANK($A$7:$A$9,A7)
Turkish Excel · tr-TR
=YÜZDERANK($A$7:$A$9;A7)

Compatibility function for older workbooks.

Worked examples

Check the inclusive endpoints of the legacy percentile ranking function.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Trial
7 10
8 20
9 30
Case Formula Expected result
Record 1 =PERCENTRANK($A$7:$A$9,A7) 0
Record 2 =PERCENTRANK($A$7:$A$9,A8) 0.5
Record 3 =PERCENTRANK($A$7:$A$9,A9) 1
Microsoft Excel reference