Hi, I'm very new to excel and trying to understand how to use the program.
I'm trying to make a monthly tracker of how I spend my money, I would like the overall balance to remain empty until the corresponding money out column is filled in.
I've tried many things, such as different formulas, and formatting. But I can't get it to work, any ideas on what I should do? I am willing to remodel this.wat.JPG
Try...
=IF(F4<>"",SUM(G3+E4-F4),"")
Last edited by jeffreybrown; 10-03-2018 at 06:43 PM.
HTH
Regards, Jeff
Drag down to fill.
Please Login or Register to view this content.
Last edited by Entregan; 10-03-2018 at 06:46 PM.
Why even use the SUM function here?
=IF(F4<>"",G3+E4-F4,"")
OR
=IF(F3="","",G3+E4-F4)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Long day I guess.Originally Posted by FDibbins
In case Faz decides to get more detailed and itemizes by column?
Thank you all it worked, and lol it's because I was trying loads of things to get it to work, at first I didn't include the sum, but then I did as I was trying out more things, so in a way kinda a long day
Thank you again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks