The syntax of Excel’s percentile functions
Both functions include the same arguments. The array argument is the range of numbers that you’re looking in for the percentile.
Value is the percentile rank you’d like to find.
Both of these will make more sense when we go through an example.
The difference between these two functions is that the first is exclusive, and the second is inclusive. In short, the percentile ranks available in the exclusive function don’t include 0 or 1, while both can be used in the inclusive function.