\nThe following is how I understand it.<\/p>\n
\nLet’s imagine this scenario: cost is 1000 +0.44x, while revenue is 1.5x, where x is units sold. What, then, is the break-even point for units sold?<\/p>\n
In LibreOffice Calc, Goal Seek could be used to find the break-even point.<\/p>\n
\nIn one cell (say a3), one types the formula 1.5*c3 – 0.44*c3 – 1000.<\/p>\n
\nIt seems to me that the variable cell (in this case c3) needs to be initialized in order for Goal Seek to work. So, in this case, one might just enter 0 in c3.<\/p>\n
\nNext, in the Tools menu, find Goal Seek. It first asks what the Formula cell is, which in this case would be a3. Next, it asks what the Target value is: in this case, 0. Finally, it asks for the Variable cell: in this case, c3. Next, click OK or else press Enter.<\/p>\n
\nWhen I did so, Goal Seek replied that it had succeeded, and that the answer would be 943.396 (to 3 decimal places). It asked if I would like that value entered into the variable cell, and I clicked Yes. 943.396 then appeared in c3.<\/p>\n
\nSlick, eh?<\/p>\n
Source:<\/p>\n