Any idea why this formula returns a 4 digit number?

=IF(PERCENTRANK(EV$2:EV$5000,EV3)<50,(50-(PERCENTRANK(EV$2:EV$5000,EV3)))+50,PERCENTRANK(EV$2:EV$5000,EV3))


column EV has a bunch of three digit numbers ranging from 100% to 1300%


What I am trying to do is calculate the percentile rank of EV3, and if EV3 is below the 50th percentile, I want it to display EV3's percentile+50. If EV3 is above the 50th percentile I just want it to display its actual percentile.

So basically if the percentile for EV3 is 34%, I want the formula to display 66%. IF the percentile for EV3 is 56%, then I want it to display 56%.

What am I doing wrong?

Try this.......

=IF(PERCENTRANK(EV$2:EV$5000,EV3)<50%,(50%-(PERCENTRANK(EV$2:EV$5000,EV3)))+50%,PERCENTRANK(EV$2:EV$5000,EV3))