Yes, I wasn't 100% sure - because there is nothing in your workbook that fits your specification of "how many % away from next rank". How is anyone supposed to provide the solution for that when there is nowhere apparent for it to go?

According to your specifications, the 19161 rank points in F2 is greater than the 15000 rank points in B6 required to achieve rank 5 (A6). So I don't know how you can say:
As for:
there is no 35% figure in the workbook I posted. There is a 28% figure in E2, representing the percentage by which the 19161 rank points in F2 exceeds the 15000 rank points in B6, and a 2% figure in L2, representing the percentage by which the 15238.8 rank points in H2 exceeds the 15000 rank points in B6.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The 19161 "rank points" are suppose to be only "points" ehm.. it was just a note for my self that i assume only i would understand sry about that.

"point = honor" so if you look at the imiage, u will notice that it wont get so high as rank 5.

you wont be able to see under 6000 rank points btw, only from 6000 RP and up to 14000 RP.
So if you look at the imiage you will have 7000 Rank points WHEN you got 50000 points/honor
Out of the 7000 Rank points you get, you will get Rank 3 and some % inside that rank.
hope that made a few things more clear?