Question

write the steps to use goal seek and solver​

Answer 1

Explanation:

Click Data > What-If Analysis > Goal Seek. ...

Put the "equals" part of your equation in the Set Cell field. ...

Type your goal value into the To value field. ...

Tell Excel which variable to solve for in the By changing cell field. ...

Hit OK to solve for your goal.

Answer 2

Goal Seek in OO Calc.

• Place the cursor in B4 cell and click on Tools → GoalSeek option.
• A Goal Seek dialog box appears as displayed in the following screenshot.
• Type the desired value for target value and select the variable cell to display the changed value.
• Now click on OK button.