| Set Scenario in Goal Seeker Analysis |  |
Then click on the Gear icon button (Run goal seek).
|
|||
|
|||
| The Goal Seek and Breakeven options show all input and output unselected! by default. You have
to select the variables you want to apply Goal Seek to by checking the checkboxes, then choosing
where you want to paste the result. |
|||
|
|||
| In this example we have chosen to work with all, apply Breakeven and paste the result at cell C13 within the same sheet. Then click on the Gear icon button (Run goal seek). |
|||
|
|||
| The results are shown in the same spreadsheet: | |||
|
|||