Voci con l'etichetta :
Chiudi
Changelog
Chiudi
Voci con l'etichetta :
Chiudi
Provalo nel cloud

Goal Seek

ONLYOFFICE Spreadsheet Editor offers a Goal Seek feature that allows you to determine which numbers should be substituted into the formula to obtain the desired and previously known result.

  1. Open the Data tab and click the Goal Seek icon on the top toolbar.
  2. In the opened Goal Seek window, select the necessary options:

    Goal Seek

    • Set cell - enter the reference to the cell that contains a formula. You can use the
      icon to select the cell.
    • To value - enter the result you want to get in the cell containing the formula.
    • By changing cell - enter the reference to the cell that that contains the value you want to change. You can use the
      icon to select the cell. This cell must be referenced by the formula located in the cell which you specified in the Set cell field.
  3. Click OK.
  4. The  Goal Seek Status window will display the result.

    Goal Seek status

  5. Click OK to replace the values in the the cells specified in the Set cell and By changing cell fields.
Alla pagina precedente
Try now for free Try and make your decision No need to install anything
to see all the features in action