You really do need to explain your problem more clearly. I gather you're now referring to the cells in G32:H41. If so, how do they relate to cells A2:B15 and your other data?

Until you can explain clearly what results you expect to see in every range, and how they relate to the data tables in your workbook, you can't expect to get the help you want.

So, in answer to your question: no you haven't made things clear.

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

Honor = points
RP = rank points

1. My amound of honor is 100.000
2. If you follow the table (Image) it will say around how much RP that it will give me
3. out of that amound of rank points I wounder.. how many ranks do i earn and how far into this rank did I get

Your idea have made it so I get rank 5 and 28% into rank 5.
The problem is, when you read the table it says I will get like.. only get rank 2.

What is the part you dont understand?

For starters, you haven't said anything about where (what cell address) your 100.000 would go or where the RP it gives should appear. neither have you said how the cells in G32:H41 relate to cells A2:B15 and your other data.

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