Note that when the GoalSeek dialog box is being completed, the target value needs to be typed in as hard-coded figure; it is not possible to use a cell reference. This is inconvenient if the target value is not a simple figure to input by typing.
It is generally better to have the target value input into a cell, and to subtract the value of this from the model’s output, to create a “difference” calculation. Then, one can apply GoalSeek so that this difference is required to be zero.
An example is shown in the image below, in which one desires to achieve a Profit of 5452. This has been input into cell C14, and the difference calculated in cell C15, which becomes the target cell with a value of zero.