If I have a simple equation, like
A1 = Total Revenue
A2 = Cost of Revenue
A3 = Gross Profit = A1 - A2

And I want to automate some goal seeking using Solver, is there any
way to tell it to try and keep A1 and A2 in the same ratio? I don't
want to make A2 a calculation if possible.

When I try solver, if my initial numbers are 100-50=50, and then I try
to goal seek to 75, I get 113-38. I would like to get 150-75. Is
there any setting for Solver to tell it to try to find solutions like
that?

thanks
Backslider