81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

PERCENTILE.EXC()

Description

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

How To Use in Sheets

PERCENTILE.EXC(data, percentile)

External Links

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.

Google Docs Help

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.