# Frequently asked questions - Calc

TDF LibreOffice Document Liberation Project Community Blogs Pootle Nextcloud Redmine Ask LibreOffice Donate

## Where is the solver in Calc ?

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**.

The spreadsheet will show you if it has reached the target value and will suggest inserting a suitable value into the variable cell. Failing that, it will suggest a value for the variable cell which gets you as close as possible to the target value.

It is possible to use other tools, such as the **Fitoo** macro, a non-linear correlation tool, created by Laurent Godard, available at [2].

For polynomial correlations, there is the CorelPolyGUI extension.