How to increase two values to match a ratio of 17:8 in Google Sheets

If I have two values with a calculated ratio for example:

Value 1 = 5000  Value 2 = 100    Calculated Ratio = 50:1  

How do I distribute a value of 500 between value 1 and value 2 so I can get to a 17:8 ratio or as close as possible to 17:8 ratio without decreasing any of the values.

I tried adding all the values and then splitting them into 17:8 ratio but this will in some cases decrease one value to get to another.

Incorrect example as value one has decreased from its original value of 5000:

Value 1 = 3808  Value 2 = 1792  Calculated Ratio = 17:8  

https://stackoverflow.com/questions/67396305/how-to-increase-two-values-to-match-a-ratio-of-178-in-google-sheets May 05, 2021 at 02:43PM