Select the "Set Cell"This is the cell whose value is calculated by a formula (e.g. a profit cell that depends on price or cost).
Choose the cell that contain the value you want to set
Click "Add Set Cell”The selected cell(s) will be displayed next to the button.
Select the "Changing Cell"This is the input cell you want to tweak so that the "Set Cell" reaches your target value.
Choose the cell that contain the value you want to changeClick "Add Change Cell”
The selected cell(s) will be displayed next to the button.
Enter a Target ValueType the number you want the Set Cell to reach. For example: 10000. Please only enter numbers.Click "Run Goal Seek"

✅ The tool will automatically try different values in the Changing Cell until the Set Cell reaches the Target Value — or as close as possible!