Wrong formula QUARTILE

%3CLINGO-SUB%20id%3D%22lingo-sub-2763497%22%20slang%3D%22en-US%22%3EWrong%20formula%20QUARTILE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2763497%22%20slang%3D%22en-US%22%3E%3CP%3EThe%203rd%20quartile%20result%20is%20wrong%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2763497%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2763518%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20formula%20QUARTILE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2763518%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1159867%22%20target%3D%22_blank%22%3E%40Sadek_Youssef%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EQUARTILE%20is%20a%20legacy%20function%20that%20has%20been%20replaced%20with%20two%20new%20functions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20%3DQUARTILE.EXC(%24A%241%3A%24A%2413%2C%24D4)%20or%20%3DQUARTILE.INC(%24A%241%3A%24A%2413%2C%24D4)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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)