Finding Max value?
Finding Max value?
(OP)
Does anyone know how to find the value in one cell that will result in an equation in another cell producing its max value?
SIMPLIFIED EXAMPLE:
A B
1 ? -(X-3)^2
2
A B
1 3 0.0
2
Again this is a simplified example. My actual spreadsheet is pretty complex so dragging A1, & B1 down as A1 increases really isn't an option. And I've had enough of the trial & error technique.
SIMPLIFIED EXAMPLE:
A B
1 ? -(X-3)^2
2
A B
1 3 0.0
2
Again this is a simplified example. My actual spreadsheet is pretty complex so dragging A1, & B1 down as A1 increases really isn't an option. And I've had enough of the trial & error technique.





RE: Finding Max value?
Solver may have a decent stab at it, depending on the complexity of your response space. In this case your target would be to maximise B1 by varying A1.
Otherwise, read many of the threads below on optimisation.
Cheers
Greg Locock
RE: Finding Max value?
RE: Finding Max value?