Microsoft Office Tutorials and References
In Depth Information
Working with Logical Functions
9. Click cell N40 to deselect the range. The new savings account balances are shown
in Figure 3-33.
Monthly savings account balances
click to view logical
net cash flow is >=
$1,000 every month
June, and August
$800 is transferred
every mo nth except
January, June, and
With this savings plan, the ending balance in the main savings account remains
above $3,000 for most months of the year, and $800 is transferred from the main
savings account into the home savings account in nine months of the year. Only in January,
June, and August will Diane not transfer money into the home account. By the end of the
year, the couple will have $5,350 in the main savings account and $7,200 in the home
Diane wants to explore what would happen if she increases the monthly transfer from
$800 to $1,000. How would that affect the monthly balance of the main savings account?
To change the conditions of Diane’s savings plan:
1. Change the value in cell L10 to 1000 . The end-of-year balance in the home
savings account increases to $9,000 (cell L6) while the main savings account balance
decreases to $3,550 (cell L5).
2. Scroll down the worksheet and examine how the monthly balance in the main
savings account changes throughout the year. Under this revised plan, the balance in
the main savings account drops to $1,775 in the month of August. This is a little
too low for Diane.
3. Change the value in cell L10 to 900 . With this savings plan, the couple will
save $8,100 toward a down payment on a home, and the balance in their main
savings account will remain above $2,000 every month except January, when it
dips to $1,940.
Diane feels that this revised savings plan is a good compromise between the need to
save money for their future home while still maintaining a decent balance in their main