4 ms·
Google Sheets doesnt have Solver in the consumer version for one. In reference to your second statement though, I also dont always carry my laptop but it doesn
by arcbyte 2y ago
Google Sheets doesnt have Solver in the consumer version for one.
In reference to your second statement though, I also dont always carry my laptop but it doesn't matter because my spreadhseets are in onedrive too, so I can close my laptop and open my phone and have the same spreadsheet with zero thought.
- Andrex 2y agoWhat 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.