Enter your data in a single column or row
Select an empty cell for the result
Use `=QUARTILE.INC(range, quart)` for inclusive quartiles
Use `=QUARTILE.EXC(range, quart)` for exclusive quartiles
Replace `range` with your data range, such as `A1:A20`
Use `quart` as:
`0` for minimum
`1` for first quartile
`2` for median
`3` for third quartile
`4` for maximum
Press Enter to calculate the quartile
Repeat the formula for each quartile you need
Use `=QUARTILE.INC(A1:A20,1)` for the first quartile
Use `=QUARTILE.INC(A1:A20,2)` for the median
Use `=QUARTILE.INC(A1:A20,3)` for the third quartile
Use `=QUARTILE.EXC(A1:A20,1)` if you need exclusive quartiles
Sort the data if you want to inspect the values manually
Use `=PERCENTILE.INC(range,0.25)` for the first quartile
Use `=PERCENTILE.INC(range,0.5)` for the median
Use `=PERCENTILE.INC(range,0.75)` for the third quartile