 # How To Use PERCENTILE.EXC()

Description

Returns the value at a given percentile of a dataset, exclusive of 0 and 1.

Common questions about the PERCENTILE.EXC formula:
1. What range of numbers is included in the formula calculation?
2. How can the PERCENTILE.EXC formula be used to calculate a percentile rank?

The PERCENTILE.EXC formula can be used appropriately by inputting a numerical range for the calculation of the percentile, specifying the percentage to be calculated, and using the correct syntax to get the formula to work properly.

The PERCENTILE.EXC formula can be commonly mistyped by not including the “.EXC” portion of the formula or writing the syntax incorrectly.

Common ways the PERCENTILE.EXC formula is used inappropriately include using the formula with non-numerical data, not specifying the correct percentage, not including the “.EXC” portion of the formula, or attempting to use the formula with a set of numbers that doesn’t include enough values.

Common pitfalls when using the PERCENTILE.EXC formula include mistyping the formula, not specifying the correct percentage, or not including the “.EXC” portion of the formula.

Common mistakes when using the PERCENTILE.EXC formula include not specifying the correct numerical range for calculation, not entering the right percentage for calculation, or trying to use the formula with a set of numbers that doesn’t include enough values.

Common misconceptions people might have with the PERCENTILE.EXC Formula include thinking it's used for categorizing data, thinking that all the data in the spreadsheet are included in the calculation, or not understanding that decimals must be used for the percentage.

How To Actually Use PERCENTILE.EXC() in Sheets

`PERCENTILE.EXC(data, percentile)`

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

PERCENTILE.INC vs PERCENTILE.EXC Statistical Function with Example in MS Excel 2016

This video shows you PERCENTILE.INC vs PERCENTILE.EXC Statistical Function with Example in MS Excel 2016.

Better Sheets