I have a percentile calculator in excel but I was wondering if I could replicate this in PowerApps so I can put it on SharePoint and make it web based.
We do not have to put in the Hourly Rate in there. The most important thing is the value in yellow.

This is the formula that is in i11 which creates the percentile interpolation.
=NORMSDIST(TREND(NORM.S.INV(SMALL(LEFT(E10:H10,2)/100,IFNA(MIN(MATCH(D11,E11#),3),1)+{0,1})),SMALL(E11#,IFNA(MIN(MATCH(D11,E11#),1),3)+{0,1}),D11))*100