4 ms·
What problem does Solver solve? Reading the overview, I don't really understand how it would be useful. https://support.microsoft.com/en-us/office/define-and-s
by Andrex 2y ago
What problem does Solver solve? Reading the overview, I don't really understand how it would be useful.
https://support.microsoft.com/en-us/office/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040 https://support.microsoft.com/en-us/office/define-and-solve-...
> For example, you can change the amount of your projected advertising budget and see the effect on your projected profit amount.
I can do this without Solver.
- max51 2y agoThe main use of the solver is for something that definitely cannot be done without programming vba macro. You use it to find the optimal value in a cell based on the result in a different cell. You have a cell that excels will solve, a cell with the objective and constraints. For example, let's say you have a spreadsheet to calculate the capacity of a steel column based on its height and cross-section/material. If you wanted to run the calculation backward and find the height that will give you a very specific capacity, you could do it manually by playing with the height until you find it or you can let Excel do it for automatically with the solver.