Goal Seek

Goal Seek

Goal Seek helps you calculate input value required to reach the result. For example, you can estimate how many products must be sold to reach a revenue goal of $2 million.
Here's how you use Goal Seek to devise estimates:
  1. Go to Data > Goal Seek.
  2. In the dialog box that appears, enter the following:
    1. Target cell: The cell containing the formula that gives the final output (e.g. revenue).
    2. Variable cell: The input cell that the formula depends on (e.g. units sold).
    3. Expected result: The output value you want to reach.
  3. After you run Goal Seek, Zoho Sheet automatically adjusts the variable cell to meet the expected result.
  4. Click Ok.