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.