I see your point but this method does not work with large series.
The PERCENTILE value must be a number that belongs to the series.

We do tables of salaries and we need to show the salary that best represents
the MEDIAN or a QUARTILE. For example:
{$50000, $50001 $50010 $50500 $50501 $65000}
The right MEDIAN value is $50010 and Excel provides $50255, this is just
wrong. $50255 does not belong the series.

"BoniM" wrote:

=INT(PERCENTILE(A1:A10,0.5))

"Francisco" wrote:

I have a suggestion that we will be very useful for our company.
The way Excel calculate PERCENTILE and QUARTILE series is not appropiate for
discrete numbers.

My suggestion
At the moment =percentile(a1:a10,.05) gives 5.5 in the sequence
{1,2,3,4,5,6,7,8,9,10}. This is incorrect on discrete numbers.

Following the example above, I want to gather discrete numbers, i.e. "5" on
the series rather than "5.5". The same apply for QUARTILE formulas where a
second parameter is needed.
Add a Third parameter [optional] as follows:
- 0, default (as it currently works)
- 1, takes the inferior discrete number
- 2, takes the superior discrete number


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc