Financial Formula

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

Does this work for you?

=IF(D4="x","Balance at Bank","Please Update")

I would like an actual number to show up IF D?=x. So if H3=500 and in E4 I have a charge of $20 (or a deposit in E5 depending on the transaction obivously) and it has gone through the bank I'll put in x in D4 and H4=$475. If the transaction hasn't been processed at the bank then I won't put an x there and H4 will say please update or be blank.

By the way, Balance at Bank is just the title of the column, there's no need for it in the formula.

Thanks a lot for helping me!

I'm a little confused here, So if H3=500 don't you mean G3 (Balance) and a charge of $20 leaves H4=$475 I think that's $480

Try this

=IF(D4="x",G4,"Please Update")

Glad you got it fixed - thanks for the feedback