Goal Seek is a powerful 'what-if' analysis tool that works backward from a result to determine the necessary input. It is perfect for calculating break-even points or adjusting budgets.
Le faire avec l'IAOpen the Goal Seek tool
Go to the 'Data' tab on the ribbon, click 'What-If Analysis', and select 'Goal Seek'.
Define the target cell
In the 'Set cell' box, select the cell containing the formula you want to reach a specific value.
Set the target value
Enter your desired result in the 'To value' box, and select the input cell to change in the 'By changing cell' box.
Execute the calculation
Click 'OK' to let Excel find the solution and update your spreadsheet.
No, Goal Seek can only change one input cell at a time. Use the 'Solver' add-in for more complex problems.