Returns a requested quartile of a supplied range of values, based on a percentile range of 0 to 1 exclusive.
Data represents the range of data values for which you want to calculate the specified quartile.
Type An integer between 1 and 3, representing the required quartile. (if type = 1 or 3, the supplied array must contain more than 2 values)
The difference between QUARTILE.INC and QUARTILE.EXC is that the QUARTILE.INC function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the QUARTILE.EXC function bases its calculation on a percentile range of 0 to 1 exclusive.
=QUARTILE.EXC(A1:A50;2) returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.