Excel will only accept values and not a cell reference.īy changing cell - This specifes the cell of the variable you want to change, in order to obtain the final result. To value - This is the value which you are trying to reach. Set cell - This specifies the cell containing the formula that is used to obtain the final result. You can select (Tools > Goal Seek) to display the Goal Seek dialog box. This uses a single variable to find a desired result. The Goal Seek is useful for problems that involve an exact target value that depends on a single variable. You can build complex worksheet models and then employ the Goal Seek feature to derive different solutions to your models. The Goal Seek feature is only useful for problems that involve finding a single variable. This allows you to calculate an unknown value in a given formula.
0 kommentar(er)
