How To Use QUARTILE.EXC()

Description

Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4..

How To Actually Use QUARTILE.EXC() in Sheets

QUARTILE.EXC(data, quartile_number)

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.

Learn more about the QUARTILE.EXC() formula: