Loading suggested videos
=QUARTILE.INC( to begin., and choose a number from 0 to 4 to specify the quartile:
0 = Minimum1 = First quartile (Q1)2 = Median (Q2)3 = Third quartile (Q3)4 = MaximumEnter.=QUARTILE.INC(A1:A10, 1))
Result: Excel will return the quartile value based on your selected range and quartile type.
Tip: You can also use QUARTILE.EXC for exclusive quartile calculation, which excludes the minimum and maximum in Q1–Q3.
Your feedback helps us improve our content.