PERC Calculates the nth Percentile and returns the value at that position.

SYNTAX:

PERC(Cell_Range,Percentile) 

Cell_Range:  The cell range in the report to analyze. 

Percentile: The percentile number (i.e. 95 to get the 95th percentile).

Notes:

• If there is not an exact match for the percentile/number of values, Perc will use Scientific Rounding to calculate the slot to return.  Example, 90th percentile of 16 values would return the value at the 14th slot of the ordered list (16 * .9 =14.4 rounded to a whole number is 14).  
• Perc returns no value (i.e. blank) if there are more than 10,000 values in the range.

EXAMPLES:

PERC(B3:B33,95)