Forum Discussion
Checkbook Register with Automatic Round-Up to Savings Feature
Hello mathetes,
I took some time and was able to get the Roundup formula to do some of the simple tasks I wanted the Roundup formula to complete. Although I couldn't figure out how to get the information to display on a separate page. So, I thought I'd try a simple Value Lookup, and use that as a constant update number on the Savings Account Page then just enter Transfers Manually, but that was unsuccessful. Here is what I am currently working on though.
I still would like to accomplish what I mentioned in the first reply if you see it possible.
Thanks,
DC_BarTroN
Kept thinking about it, and came up with a minor revision in part just to illustrate a simple way to change the ROUNDUP formula itself, should you decide to be more aggressive in the amounts you devote to Savings.
This uses a named range (set up on the second worksheet, which I've named "Bus Table" to indicate the fact that you can add other tables there. There's a named range created, called "RoundUpDeg" --to enable easy changes to the degree you do your rounding. Change the value in cell B1 to -1 and your rounding goes to the nearest 10 dollar figure, greatly increasing you savings rate, yet still (hopefully) not breaking your checking account balance. The formula need never be changed, just the value in that single cell.
=ROUNDUP(D5,RoundUpDeg)