Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4..
Learn ↓
Description
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:
Better Sheets
Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.
Start 7 Day Free TrialGoogle Sheets Help
Google Sheets Courses
Google Sheet Templates and Tools
Google Sheet Add Ons