Hi everybody,
I have an excel Checkbook Register template I downloaded but I took the formula out of that one and I am making my own. I'm trying to create a special formula, but I can't quite figure it out.
Column E=Transaction amount
Column F=Deposit amount
Column G=Balance
the formula in G4 is: =IF(AND(ISBLANK(E4),ISBLANK(F4)),"",G3-E4+F4)
In column D I am putting an lowercase x to keep track of when the transaction goes through the bank.
I want a formula that will be in column H, called Balance at Bank. What I want is so if D4=x, H4 will calculate that for me so I know how much the bank thinks I have...make sense? If D4 has no x, I would like it to display a message like "Please update" or better yet just be blank (but I'd like to know how to display text in the event I need such a formula later). I just can't seem to get it to work.
Thanks a lot
Bookmarks