Here is a list of steps you can take to use the Goal Seek function in Excel:
- Under the Data tab, select what-if analysis, and then select goal seek
- You will be asked to indicate which cell contains the formula, the target value, and the changing cell
- Adjust the changing cell so the resulting value of the formula matches the target value