Translations:Faq/Calc/109/2/en
The multivariable solver integrated into LibreOffice is activated by the Menu
▸ .The solver engine by default supports only linear equations, but the NLPSolver extension allows you to handle non-linear problems. You will find a full explanation of its functioning on [1].
Yous can also use the tool Goal seek :
- 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).
- Go to ▸ .
- In Formula Cell, indicate the coordinates of the cell containing the formula which needs to attain the target value.
- In Target Value, indicate the value that should be reached in the preceding case.
- In Variable Cell, indicate the coordinates of the cell whose value is unknown and will be modified.
- Click OK.