Forum Discussion
Wrong formula QUARTILE
The 3rd quartile result is wrong
QUARTILE is a legacy function that has been replaced with two new functions.
Use =QUARTILE.EXC($A$1:$A$13,$D4) or =QUARTILE.INC($A$1:$A$13,$D4)
QUARTILE is a legacy function that has been replaced with two new functions.
Use =QUARTILE.EXC($A$1:$A$13,$D4) or =QUARTILE.INC($A$1:$A$13,$D4)