In ‘Set cell’, enter the cell reference, which will contain your desired result (in our case, B15). We will use Goal Seek to arrive at the required income value.Īfter selecting the Goal Seek command, a pop-up window will appear. But to how much?īy using the Goal Seek command, we can indicate a desired outcome, and Excel will determine the adjustment we need to make to a single variable. If you would like your savings to be 10% of your income, and assuming that you are unable to reduce your expenses, you realize that you must increase your income.
Your savings (B14) are shown as the difference between the two and displayed as a percentage of your income in cell B15. To illustrate how it works in a simple example, imagine that cell B1 (below) displays your monthly income, and cells B3 to B11 shows your expenses.
0 kommentar(er)
