LibreOffice Calc - Goal Seek

LibreOffice Calc - Goal Seek

LibreOffice Calc may not be as powerful as Excel, or easy to use, but it works in 90% of cases.

Above is the usual table, we have an initial value and multiply by a tax value to obtain the final value.

But if we need to sell at a fixed price, we need to find the initial value before taxes.

In MS Excel the have a similar feature, Goal Seek. In LibreOffice Calc is almost the same.

In this clean example, we could fill the final value as 30 and try to find the initial value

The approach is not fill now the value 30.

You need to fill a formula before.

Now enter the Goal Seek.

You obtain the result.