Hello
I have attached a view of my very first spreadsheet which is a simple way of tracking savings.
I figured out the formula for a running balance but I can't understand why the current balance has filled down the entire column. Is that normal? The formula is =SUM(E5,B6-C6)
Belinda xxx
Hi there hopefully this will be of use to you
=IF(SUM(B5:C5)=0,"",SUM(E4+B5)-C5)
maybe not the most elegant way of doing it but hopefully will work ok
mmm cant attach workbook, let me know if you need it
Good afternoon Belinda
...and welcome to the forum! (and congratulations on your first ever spreadsheet)
This is normal but only because you have copied the formula down. Look carefully at the formulae you have copied down the screen and you will notice that Excel has "intelligently" changed the cell references moving down. the upshot of this is that as you enter more of your personal income and expenditure this value will change - looking more sensible than it does right now.
You have two choices at this stage : live with it as it is (which is what I would do), or ebery time you enter a new transaction, copy the formula down a row to refelect the new balance.
As you get further into this Excel lark you'll pick up tricks such as learning how to hide this value, unitl it contains something, but first things first eh?
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks