# PERCENTILE.EXC

### Definition

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

### Syntax

PERCENTILE.EXC(array,k)

The PERCENTILE.EXC function syntax has the following arguments:

• Array     Required. The array or range of data that defines relative standing.

• K     Required. The percentile value in the range 0..1, exclusive.

### Remarks

• If array is empty, PERCENTILE.EXC returns the #NUM! error value

• If k is nonnumeric, PERCENTILE.EXC returns the #VALUE! error value.

• If k is ≤ 0 or if k ≥ 1, PERCENTILE.EXC returns the #NUM! error value.

• If k is not a multiple of 1/(n - 1), PERCENTILE.EXC interpolates to determine the value at the k-th percentile.

• PERCENTILE.EXC will interpolate when the value for the specified percentile lies between two values in the array. If it cannot interpolate for the percentile, k specified, Excel will return #NUM! error.

### By adding the values you would like to calculate the PERCENTILE.EXC formula for, Excellentable will generate the outcome:

A
B
1
Data
Value
2
1
3
2
4
3
5
6
6
6
7
6
8
7
9
8
10
9
11
12
PERCENTILE.EXC(A2:A10, 0.25)
2.5

JavaScript errors detected