Wrong formula QUARTILE

Copper Contributor

The 3rd quartile result is wrong

1 Reply

@Sadek_Youssef 

 

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)