How To Use Goal Seek In Excel For Multiple Cells

I Am Wanting To Goal Seek In One Set Cell By Changing The Values In Multiple Cells.

We want a customized goal seek, which will deliver a 30% ebitda margin based on each year’s respective revenue number. How to use goal seek in excel. Do this for rows 3, 4, and 5, as well.

Pros & Cons Of Goal Seek In Excel.

Do this for rows 3, 4, and 5, as well. Goal seek requires a single input cell and a single output (formula) cell. If you want to have excel change more input cells you need to use the solver tool.

Go To The Data Tab > Forecast Group, Click The What If Analysis Button, And Select Goal Seek….

For example, a1:h1 are my range of cells with formulas that i want to change and j1 (with a formula) is my set cell that i am wanting to goal seek. How do you use goal seek with two variables? Hit ok to solve for your goal.

However In The Above Screenshot Example, We Want To Achieve Different Goal Values Across Multiple Columns.

Goal seek multiple cells (solver) please sign up for the course before starting the lesson. Steps to use goal seek excel: Put the equals part of your equation in the set cell field.

Click The Cell That Is Using The =Sum () Function (In Our Example, Cell D6).

Select the range which the set cells will be changed to 3. Things to remember goal seek is based on the dependent and independent cells. However in the above screenshot example, we want to achieve different goal values across multiple columns.