Microsoft Office Tutorials and References

In Depth Information

**Using PERCENTRANK.INC to Assign a Percentile to Every Record**

significance
—
This is an optional value that identifies the number of

significant digits for the returned percentage value. If it is omitted,

PERCENTRANK.INC uses three digits (that is, 0.xxx). If significanceis

less than 1, PERCENTRANK.INC returns a #NUM! error.

This function is slightly different from RANK, so use caution. Typically,

RANK and other functions would ask for xas the first argument and array

as the second argument. If you use this function and everyone is assigned to

the 100% level, you might have reversed the arguments. The Excel Help is a

bit misleading with regard to significance. The Help topic indicates that a sig-

nificance of 3 generates a value accurate to 0.xxx%. In fact, a significance of

3 returns xx.x%.

student is =PERCENTRANK.INC($B$3:$B$302,B3,3). Note that

PERCENTRANK.INC always starts with the lowest score at the lowest per-

centile.

•
significance

Figure 14.10.

Figure 14.10.
The

The PERCENTRANK.INC

PERCENTRANK.INC function assigns percentile values to

function assigns percentile values to

an array of values.

an array of values.