Hi,
go to excel help and enter percentile

"Greg" wrote:

Does anyone know how Excel calculates the value it returned using the
function Precentile()?

It is not merely the interpolation of the bounding values.