IF function is a beautiful thing!! Thank You Truth is also cool too.
@excelisfun
Жыл бұрын
Glad the video helps!
@Mamaddra3
11 жыл бұрын
This guys tutorial/lesson/video just SAVED MY REAR!!! I cannot thank you enough for being so specific!! I already had the table created and I figured out the balances myself and it wasn't working as you described .... I took a break ... then realized that once I DELETED the manual balances, the formula was ... like ... WAHLAH!!!!! Thank you very much!!
@enjoymikey
12 жыл бұрын
Thank you so much for showing how to do this. Best video that can actually explain how to do this the right and easy way! You are awesome man!
@Yansyou2b
12 жыл бұрын
Thank you for explaining the formula step-by-step!!
@excelisfun
12 жыл бұрын
I am glad that you liked the video!
@excelisfun
12 жыл бұрын
I am glad that the videos help!!
@MegaChrisTech
12 жыл бұрын
You Sir are an excellent instructor. This video tutorial was incredibly helpful thank you very much.
@excelisfun
11 жыл бұрын
I am glad that you like the video!
@joanmarshall5156
11 жыл бұрын
YAY! Soo easy & simply explained. Thank you!
@TheRealDickDick
8 жыл бұрын
Excellent! thanks so much. deceptively simple. I was overthinking it.
@pdelmercado
10 жыл бұрын
Question: is there a way to keep track of the running balance on four different accounts in one checkbook? My husband and I share a checking account, but I manage our different balances ( one for household, one for me, one for him, and a running total). I have been having to record these balances in four different excel sheets using the IF formula, but I would like to combine them all on one sheet, which would also eliminate errors in entries on four different spreadsheets. I can't figure it out. Thank you
@makeittrades5750
8 жыл бұрын
You are an amazing instructor, thank you!
@davidsabin548
4 жыл бұрын
Your presentation is awesome and I like the way you walk back and forth to help me follow it better. But when I follow you example in the formula example; =H2-D3+G3, I put a number in D3 and the balance cell shows #Value error. Then if I put a 0 in the G3 the balance shows up. Going down the multiple lines, all of the balances show, #value until I put a 0 in the empty cell. I see you don't have that problem. What am I doing wrong?
@franklevasseur8831
4 жыл бұрын
Very Nice instructions! Thank you so mush!
@excelisfun
4 жыл бұрын
You are welcome, so much, Frank!!! Thanks for your support on these videos that you learn from with your comments, thumbs up, and of course your Sub. It means a lot to me and helps grow the channel so that more people can find this free education : )
@RobertoGonzalez-bx4pe
Жыл бұрын
can you tteach me how to categorize my excel register. You are a great teacher
@JunHinagdanan
12 жыл бұрын
Thanks for this nice tutorial sir, more power and God Bless...
@sugardaddy9992001
8 жыл бұрын
Great videos!!! I'm trying to familiarize myself with the most common keyboard shortcuts in excel. Do you have a workbook that helps/challenges with those? What's the check mark indicate?
@excelisfun
12 жыл бұрын
You are welcome!
@excelisfun
12 жыл бұрын
@videoman921 , you are welcome!
@excelisfun
11 жыл бұрын
Try two double quotes in value_if_true like: "" instead of 0.
@davidsabin548
4 жыл бұрын
Can you type the total formula out so that I can see it?
@JoeMartin37066
4 жыл бұрын
Thanks. Works perfectly.
@excelisfun
13 жыл бұрын
@krn14242 , you are welcome!
@kirbkl
5 жыл бұрын
Awesome! Thank you!
@excelisfun
13 жыл бұрын
@sergiososa25 , you are welcome!
@skieye1
4 жыл бұрын
Maybe a little late to the party. Hopefully you are still monitoring. Do you have any notes about reconciling? Thank you.
@IsraelGonzalezhomes
11 жыл бұрын
Great Job! The only thing is, instead of it showing blank it show 0. What did I do wrong?
@AustinBlur
11 жыл бұрын
I was sent to this link looking for a "How to" about checkbooks like this. Back in High school there was another part where we could give a "100" value code to each column where another sheet would take the total Dep. or Withdrawal and add that to the assigned code. The code would just be a number meaning like your gas bill or rent. I don't recall how you do that and would like to know. If its in another video that be convenient but if not could some one give a simple and quick "how to" on that?
@renfabrics
12 жыл бұрын
Thank you or your help!
@krn14242
13 жыл бұрын
Thanks Mike
@alindastar
11 жыл бұрын
Awesome, I mean it really, awesome.
@elainestewart6390
8 жыл бұрын
How do you add double entry where the formula still works?
@brandonhein1332
Жыл бұрын
I cant get this to work. There is always either a blank credit or withdraw amount in each line and I get an error that says #VALUE! It wont do the math unless I enter 0 into the column that I am not using. For instance if I enter a withdraw, the credit will be blank. I then have to enter 0 into that credit space or it wont formulate the calculation into the balance. How can I get it to do that without entering 0 ?
@thiruchelvibalakrishnan7780
6 жыл бұрын
How to add the amount after the minus. Example : from 10,i deduct 3 so the balance is 7.how to link the formula to get back the minus amount of 3.
Пікірлер: 39