Use Goal Seek to find the result you want by adjusting an input value - Office Support
https://support.microsoft.com/en-us/office/use-goal-seek-to-find-the-result-you-want-by-adjusting-an-input-value-320cb99e-f4a4-417f-b1c3-4f369d6e66c7
Use Goal Seek to determine the interest rate: Do one of the following: In Excel 2016 for Mac: On the Data tab, click What-If Analysis, and then click Goal Seek. ... In the Set cell box, enter the reference for the cell that contains the formula that you want to resolve. In the To value box, type the formula result that you want. In the By changing cell box, enter the reference for the cell that contains the value that you want to adjust. Click OK. ... Finally, format the target cell (B3) so that it displays...
Do one of the following: In Excel 2016 for Mac: On the Data tab, click What-If Analysis, and then click Goal Seek. ...
In the Set cell box, enter the reference for the cell that contains the formula that you want to resolve.
In the To value box, type the formula result that you want.
In the By changing cell box, enter the reference for the cell that contains the value that you want to adjust.
Click OK. ...
Finally, format the target cell (B3) so that it displays...
DA: 7 PA: 54 MOZ Rank: 24