Microsoft Excel

Hi Kyati

Thank you for your question

Goal seek is a tool that allows you to alter the value of a result cell in a formula to a specific value, by manipulating one of the input cells.

Click on Tools-Goal Seek
Enter the cell to be changed, the value it is to be changed to, and the cell to be manipluated and click OK

The scenario manager is a tools for creating multiple scenarios in a single workbook. To use click on Tools-Scenarios and then click Add to add a new scenarion
Enter the scenario's name
Identify the cells to be changed
Then click OK
You can then enter the new cell values

Then repeat the above for each new scenario

Hop this is useful

Regards

Stephen