number to number ratio / math question

Hi all,

please take a look on the attached sheet.

Math excel.xlsx

It contains two block of 3 values+ a "to subtract" column.

I'd like to know how much i have to subtract from Num1(col B), and how much i have to subtract from Num2(col F) for the ratio of the final numbers to the numbers in column C and G respectively to be the same while the sum, of the subtractions to be the number in column J.

I have given somewhat of an explanation for the first row(the sum adds up to 98 not 98.58 since i was doing this fast). I can do this pretty smooth with solver. I'd like to do it with a formula, or even on a paper sheet (pure math^^). It seems so easy but i cannot get my head around this problem.

Thanks

in D2 enter =B2/(1-D2) for the ratio in Col C. You can probably figure out the formula and apply to column G

Perhaps i didn't make myself clear. My problem doesn't lie in just calculating the ratio of two numbers - it's "a bit" more complex. As stated in the OP and as can be seen in the attached file, i would like to subtract a certain number from num1, subtract another number from num2 (the sum of subtractions has to match column J), for the resulting ratio of those numbers to the ones in column C and G to be the same.