
If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.In Excel for Windows, if you don't see the Solver command or the Analysis group on the Data tab, you need to load the Solver add-in.ġ. Click the File tab, click Options, and then click the Add-ins category.Ģ. In the Manage box, click Excel Add-ins, and then click Go.ģ. In the Add-ins available box, select the Solver Add-in check box. Use thereof is explained in our trademark policy (see Project:Copyrights for details). Their respective logos and icons are also subject to international copyright laws. "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries.

This does not include the source code of LibreOffice, which is licensed under the GNU Lesser General Public License ( LGPLv3).

The spreadsheet will show you if it has reached the target value and will suggest inserting a suitable value into the variable cell.

In Formula Cell, indicate the coordinates of the cell containing the formula which needs to attain the target value.Set out the equations for your problem, with a cell to contain the initial value that is to be determined, and another containing the formula whose result needs to reach a certain value (the target value).You will find a full explanation of its functioning on.

The solver engine by default supports only linear equations, but the NLPSolver extension allows you to handle non-linear problems. The multivariable solver integrated into LibreOffice is activated by the Menu Tools ▸ Solver.
