Contibution to High

An amusing scheme :-)
The formula below almost does what you want.

=INDEX({200,150,100,0},MATCH($B2/MAX(Achieved)*100,{0,25,50,100},1))

It's "almost" because I thought you should be more generous. I made it 50% instead of 51% and 25% instead of 26%. Note that the calculation of the percentage is very exact. 49.99999% is less than 50%. You can modify my formula, however. It's the array {0,25,50,100} which sets the limits. 0 is required to exclude negative results, 100 is needed to award 0 Rps to the winner. 50 and 25 are the values you can change. You can use 50.00001 and 25.00001 to penalise 50% and 25%. If you set the limit at 51% then 50.99999% will pay the higher fee.

The other array {200,150,100,0} contains the amounts to be given to the winner. You can change these amounts when inflation hits. The final zero is for the one who has 100%, which is the winner himself. There is no provision for a tie. The contribution would be calculated correctly for all but the two winners who both get nothing. Perhaps they will have to share the spoils. However, the highest is calculated very exactly. Rps 0.01 is all it takes to crown a king.

To make the formula work in your worksheet enter the achieved targets in column B. I assigned a name to the range comprising all achieved targets. In my worksheet that was $B$2:$B$6 and I assigned the name "Achieved". Using a name makes the formula easier to read and manage, but you can replace "Achieved" in the formula with $B$2:$B$6.

Paste the formula in row 2 and copy down. If your "Achieved" range is not in column B, change the reference to $B2 in the formula to wherever your achieved targets are.