Page 221 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

3 In the Goal Seek dialog box, define the cells/values to test and click OK
• Set cell - the reference to the cell containing the formula (B5).
• To value - the formula result you are trying to achieve (1000).
• By changing cell - the reference for the input cell that you want to adjust (B3).

4 The Goal Seek Status dialog box will appear and let you know if a solution has been found. If it succeeded,
the value in the "changing cell" will be replaced with a new one. Click OK to keep the new value or Cancel to
restore the original one.

In this example, Goal Seek has found that 223 items (rounded up to the next integer) need to be sold to achieve
revenue of $1,000.

If you are not sure you will be able to sell that many items, then maybe you can reach the target revenue by
changing the item price? To test this scenario, do Goal Seek analysis exactly as described above except that you
specify different Changing cell (B2).

208

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77