Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping inputs in proportion with Solver
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping inputs in proportion with Solver
The only way to ensure the ratio is maintained is to use a formula
(A2: =0.5*A1). If you don't want to enter that in cell A2, you can specify it as a constraint in Solver. But, one way or the other, you will have to use the formula. And, entering it into cell A2 is faster and more transparent. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Picture Proportion During Printing | Excel Discussion (Misc queries) | |||
sample vs. population proportion using a z-score in excel | Excel Worksheet Functions | |||
Showing one figure as a proportion of another in a bar graph | Charts and Charting in Excel | |||
Raise numbers in the same proportion.. | Excel Discussion (Misc queries) | |||
changing proportion of chart and data table | Charts and Charting in Excel |