Sort by time | Sort by thread (beta)
- Your queue is empty. Add videos to your queue using this button:
or sign in to load a different list.
Loading...Saving...
Loading...Saving...
Thank you so much!! This video is perfect, I'm all set up and this has really made my life easier. I really appreciate this tutorial!
SPoil3dMilk 1 day ago
Thanks so much!!! VERY good video!!! Though i thought you had a formula in your description , but then i downloaded your template and just use that, thank you very much
stasisnu18 3 weeks ago
IT ALL WORKS EXCEPT IT WON'T SUBTRACT. i CHECKED THE FORMULA FOR OPEN OFFICE FIVE TIMES :(
AndreaMaranoMakeup 3 months ago
This has been flagged as spam show
For whatever reason, the formula posted in the video did not work for me either. My goal is to create a checkbook register inside my Google Docs, and as of Sept 2011, the following worked well......
=+G2+E3-F3
This very simple formula works, but will display the balance all the way down your spreadsheet. After a little googleing, I found this to work and eliminate the repetitive running balance.
=IF(AND(ISBLANK(F3),ISBLANK(E3)),"",G2+F3-E3)
Please note I used columns E,F,G and not D,E,F.
414kj 5 months ago
Comment removed
414kj 5 months ago
Comment removed
414kj 5 months ago
if your using excel 2010 use =IF(D3>0.01,F2-D3+E3,IF(E3>0.01,F2-D3+E3,))
epiclovemuscle 6 months ago
this works like a charm! Thank you so much!
likinghills 7 months ago
thank you very much, i just got a job, and this is a great way to start!
rcfreak363 1 year ago
Thanks so much for this video!
claresa14 1 year ago
I wasn't aware until recently that OpenOffice formulas use semi-colons where Excel uses commas (or such was the case in this formula). In other words, if you're using OpenOffice, replace the commas with semi-colons and it should work just fine.
ryanatcheapchucky 1 year ago
awesome video, your the best thank you very much
nejehyusuf 1 year ago
Do you still plan on putting the formula in the description?
joe42968 1 year ago
@joe42968 I apologize for the delayed response. Apparently, YouTube does not let you use ">" in the video description so I added the formula into the video as a speech bubble. You can find that at 3:30.
ryanatcheapchucky 1 year ago
@ryanatcheapchucky Is this: IF(D3>0.01,F2-D3+E3,IF(E3>0.01,F2-D3+E3,""))
the correct formula? It doesn't work for me.
tink53150 1 year ago
@tink53150 use this if your useing excel 2003 =IF(D3>0.01,F2-D3+E3,IF(E3>0.01,F2-D3+E3))
drago812 1 year ago
the formula isn't in the description.
twofourteen 1 year ago