Question: how to create a goal seek formula in excel?
Answer: Create a spreadsheet in Excel that has your data. ... 
Click the cell you want to change. ... 
From the Data tab, select the What if Analysis… ... 
Select Goal seek… from the drop down menu.
In the Goal Seek dialog, enter the new “what if” amount in the To value: text box.