Hi. Canada here. It's late 2021, and this formula is genius. I have no knowledge of any of this, but I used your formula and populated it into my sheet - and it worked. The first time. Perfectly. Thank you!
I knew how to add a column but nothing else. I went back and forth between the video and my spreadsheet and lo and behold I think I've got it! This was so very helpful to an "older lady". lol Thank you!
Awesome! Sure beats having to pay a yearly subscription fee to Quicken. I don't need all the whistles and bells of Quicken, only a checkbook or savings account register. And this simple spreadsheet is perfect!
Huge help this video too. I knew how to do the first step but didn't know the rest. What I really want to do and wonder if it's even possible.. is to create a balance on a website for example much like my bank account. Maybe on a website I've made for example, once logged in I could reference a single cell where the updated balance would be. The problem there though would become that with what you're doing above the updated cell reference is changing constantly down the page. Is there a way then through a formula to IMPORTRANGE from whatever the most recent changed balance is? So that then whatever is ported to the website would be my updated balance?
Great video. I'm interested in learning how to make the lines below the last ledger input be blank instead of having the last balance. Have you done a video on this since you made this one? Thanks in advance.
Hey Tom. Haven't done a video on that but you'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
@@gibsonedu I tried to follow this but am SO LOST. PLEASE do you have a video made yet to show how to get my checkbook register not showing the last balance value in all future rows of the balance column? PLEASE! - and Thank you :-)
@@christinelehman8890 Hey Christine, I don't have a video for that but I think this website may help with what you're trying to do - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
Good video, very clearly laid out. Did you come up with a way of not having a "Balance" showing in that column until there is a transaction (deposit or withdrawal) next to it?
How do I add current account balance as opposed to monthly income. (My pay is not monthly it’s lump sum amounts on random dates so it is difficult to calculate a monthly income)
super helpful! thank you so much for explaining this in such great detail! I can never find an app that does what I want. Now, I can make my own check ledger!
This video is from a while ago, but I found it helpful. However I am having one issue I would like to clean up. When I copied the formula to the other cells in the balance column it copies the same number to every cell containing the formula below the last row where I entered transactions. That result shows up in your video for a second before you cleared the formula from unused rows. Is there any way to make those cells stay blank until I enter a transaction into that row? It is much cleaner to have the last cell containing a value -aka: my current balance. I tried conditional formatting but can't get it to hide text if the value of that cell is equal to the above cell. Thanks in advance.
Haven't done a video on that but you'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
I was wondering, I am trying to imitate an actual bank with made up currency, I want to have one cell with the amount of money that the bank holds, and multiple accounts. If I could have every time someone makes a deposit or withdrawal from my spreadsheet it would only affect one cell
You'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
Ryan Newell Ha sorry to disappoint. This was actually a video I made for students in my math class to help them track expenses in our classroom economy.
Very helpful, I just found an algorithm that leaves all the subsequent cells empty until one inputs a value (10:52), found it in spanish... from the Excell syntax at (which work for Google Sheets) : foro.todoexcel.com/threads/funci%C3%B3n-si-esblanco.29859/, the algorithm is: =SI(Y(ESBLANCO(D7);ESBLANCO(E7));"";F6-D7+E7), ESBLANCO is obviously ISBLANK XD, nothing is obvious here XD, hope this helps someone cause I struggled so much. Never give up! Theres always an answer, computers are dumb, but at least they don't lie! Thanks again.
@@gibsonedu I guess I am going to need it since I cannot find out how to have an automatic balance without showing the last total on every line I copied the formula onto.... I know, first world problems.
I just recently found and needed this video (big help!), But here is the formula everyone is looking for =IF(AND(ISBLANK(C3),ISBLANK(D3)),"",E2+C3-D3)
thank you for this formula... it was very helpful
Oh my goodness THANK YOU!
You're good. You're very good!
how tou array this formula?
Hi. Canada here. It's late 2021, and this formula is genius. I have no knowledge of any of this, but I used your formula and populated it into my sheet - and it worked. The first time. Perfectly. Thank you!
I knew how to add a column but nothing else. I went back and forth between the video and my spreadsheet and lo and behold I think I've got it! This was so very helpful to an "older lady". lol Thank you!
Yes! Happy spreadsheeting 😃
Thank you ,TG. This video was a life saver. I was over thinking the register. You made it so simple.
Glad it helped!
Thanks so much! This is so helpful. No more boring and time consuming paper logs!
Glad it was of use to you Wil :)
Awesome! Sure beats having to pay a yearly subscription fee to Quicken. I don't need all the whistles and bells of Quicken, only a checkbook or savings account register. And this simple spreadsheet is perfect!
Right on! Glad you found it helpful Lalo.
Huge help this video too. I knew how to do the first step but didn't know the rest. What I really want to do and wonder if it's even possible.. is to create a balance on a website for example much like my bank account. Maybe on a website I've made for example, once logged in I could reference a single cell where the updated balance would be. The problem there though would become that with what you're doing above the updated cell reference is changing constantly down the page. Is there a way then through a formula to IMPORTRANGE from whatever the most recent changed balance is? So that then whatever is ported to the website would be my updated balance?
Not sure as building out spreadsheets isn't really my expertise.
Great video. I'm interested in learning how to make the lines below the last ledger input be blank instead of having the last balance. Have you done a video on this since you made this one? Thanks in advance.
Hey Tom. Haven't done a video on that but you'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
@@gibsonedu I tried to follow this but am SO LOST. PLEASE do you have a video made yet to show how to get my checkbook register not showing the last balance value in all future rows of the balance column? PLEASE! - and Thank you :-)
@@christinelehman8890 Hey Christine, I don't have a video for that but I think this website may help with what you're trying to do - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
Great video. I'm an old dog that actually learned something... you're a great teacher.
I agree! Every time I need a refresher course, this is my go to!
Good video, very clearly laid out. Did you come up with a way of not having a "Balance" showing in that column until there is a transaction (deposit or withdrawal) next to it?
Check some of the other comments as I believe I left a link in some of them to a website on how to do that
Thank you so much for this clear and easy to follow video! Helped me a lot :)
Glad it helped Cedric :)
This was so incredibly helpful! You just made my job so much easier!
Great!
Sir , Is it possible to create google form template
for the above transactions?
It is but I do not have this document available to me anymore unfortunately.
Thanks for a great explanation!
You are the GOAT. Thank you for the video!
Glad it was helpful Jack!
How do I add current account balance as opposed to monthly income. (My pay is not monthly it’s lump sum amounts on random dates so it is difficult to calculate a monthly income)
Could you just add them to the sheet as they come in?
Is there a way to reconcile this register with the bank statement?
Automatically? No. You'd have to just manually put them in.
super helpful! thank you so much for explaining this in such great detail! I can never find an app that does what I want. Now, I can make my own check ledger!
I use the GoodBudget app now. I like it.
that was awesome i have applied it just and found thw result ,thanks.
Fantastic!
Thanks for the video. 8.29 is where the formula is that I was looking for!
Excellent! Happy spreadsheeting :)
This video is from a while ago, but I found it helpful. However I am having one issue I would like to clean up. When I copied the formula to the other cells in the balance column it copies the same number to every cell containing the formula below the last row where I entered transactions. That result shows up in your video for a second before you cleared the formula from unused rows. Is there any way to make those cells stay blank until I enter a transaction into that row? It is much cleaner to have the last cell containing a value -aka: my current balance. I tried conditional formatting but can't get it to hide text if the value of that cell is equal to the above cell. Thanks in advance.
I believe I left a link to another comment with answer to that but you could also search ‘leave cell empty is value is 0’ and see what comes up
Thank you I'll already know the process..Great video
Happy spreadsheeting!
Excellent tutorial for those of us who avoid formulas like the plague. :)
Ha! Hey they're not all that bad ;) Glad you found it helpful!
This is fantastic thanks for the tutorial
Glad it was helpful :)
Help!! whenever I am trying to get the formula to work and I hit enter, the total will not calculate
I hate when that happens :(
Super helpful, thank you!!!!
Sure thing Jon :)
Very helpful, but do you have a video on how to make the balance stay blank until you add a deposit or expenditure?
Haven't done a video on that but you'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
Excellent. Thank you.
You’re welcome 😃
Hi. I couldn't get the custom date format to work. anybody knows why?
This may be helpful - support.google.com/docs/answer/56470?hl=en&co=GENIE.Platform%3DDesktop
Super helpful for my checking account thank you!!🙏☺️
Happy money managing!
Great instruction video. Thank you
Glad it was helpful James! Happy money managing :)
Wonderful, big help!
Glad it helped!
Thank you so much. Great video
Glad to hear it sach!
ok this one here is an excellent video. thank u
Thanks trooper :)
Very helpful - thanks for a great video
Glad it was helpful. Happy Thursday!
Very helpful! Thank you!!
Happy banking!
Sooo helpful!
Glad to hear it Carolina :)
I was wondering, I am trying to imitate an actual bank with made up currency, I want to have one cell with the amount of money that the bank holds, and multiple accounts. If I could have every time someone makes a deposit or withdrawal from my spreadsheet it would only affect one cell
Hm, I'm not sure I understand the question. Could you give an example?
Thank you so much for this video. Really helpful. Got me out of a jam.
+Mike Paternott Excellent! Glad it was helpful :)
This was so helpful thanks
Hey glad it helps :) Happy money managing!
Thanks that was very helpful you're the best.
+Richard Clarke Hey glad you found it helpful Richard :)
Very easy to understand
Glad to hear it!
You da MAN!
Thanks Cronkite!
Thank u so much
Sure thing!
this was great useing it in 2024
Glad to hear it!
I don't know your office hours - but I would like to know how to make it blank! It's what I came to this video for! :)
You'll need something called an 'if statement' that basically says 'if the withdrawal or deposit columns are empty, then leave this cell blank, otherwise, put the balance in this cell'. This site shows you how to do that - superuser.com/questions/1063762/excel-2013-leave-cell-blank-if-it-has-no-data
Oh... I was hoping this was more of an advanced video showing how to import your balance
Ryan Newell Ha sorry to disappoint. This was actually a video I made for students in my math class to help them track expenses in our classroom economy.
@@gibsonedu lol, no worries. I did a ton of searching and turns out security does not allow spreadsheets to get past the banks login :(
Great Video!!!!
Thanks Israel. Happy banking :]
Very helpful, I just found an algorithm that leaves all the subsequent cells empty until one inputs a value (10:52), found it in spanish... from the Excell syntax at (which work for Google Sheets) : foro.todoexcel.com/threads/funci%C3%B3n-si-esblanco.29859/, the algorithm is: =SI(Y(ESBLANCO(D7);ESBLANCO(E7));"";F6-D7+E7), ESBLANCO is obviously ISBLANK XD, nothing is obvious here XD, hope this helps someone cause I struggled so much. Never give up! Theres always an answer, computers are dumb, but at least they don't lie! Thanks again.
There is always a way! Thanks Eddy 😃
Too many icon at the bottom of your screen sir.
OK :)
I came here to learn the one thing you didn't show... and I doubt I will be coming to your office for you to show me.
Good luck!
@@gibsonedu I guess I am going to need it since I cannot find out how to have an automatic balance without showing the last total on every line I copied the formula onto.... I know, first world problems.
Thank you. Very helpful video.
Thanks so much! Very helpful!