I am hoping somebody can help I am assuming this is very simple but I just can't think of a way to perform the below calculation to work in all circumstances. Number of amounts at a rate

Amount IF Shared % Rate Pay

12.55 12.55 88.75 11.14

To calculate the above using the pay amount at a different rate I can do Amount*NewRate/%Rate

The issue I have is if the Amount is shared

Amount IF Shared % Rate Pay

53.47 10.69 16.75 8.96

How can I calcuate the above at a new rate if I use the Amount*NewRate/%Rate figure is higher than the initial pay of 8.96

A system auto generates the the figures above at a set rate therefore I cannot amend the data.

Can somebody help!!!!!