What is the difference between the formula which uses PERCENTILE.EXC versus PERCENTILE.INC?  I understand what they are, but I do not understand their significance.  How would a user choose between them?  Why?


Douglas Eckert

York PA


Question Info

Last updated October 17, 2019 Views 70,927 Applies to:

The syntax is PERCENTILE.EXC(array, k) and PERCENTILE.INC(array, k)


PERCENTILE.EXC only works if k is between 1/n and 1-1/n, where n is the number of elements in array.


PERCENTILE.INC uses a slightly less accurate algorithm, but it works for any value of k between 0 and 1.

Kind regards, HansV

20 people were helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.