formula for checkbook

Y

ygl

I have a worksheet Icreated to mimick a checkbook. I'm trying to create a
formula for the balance column that would take the previous balance amount in
cell H6 and add the deposit amount, if any, in cell G7and then minus the
check amount in D7 but only if I have an "X" in E7, which means I've mailed
that check.
The following are the columns in my worksheet:
A=Check #, B=Date on Check, C=Transaction Description, D=Payment Amount,
E= Mailed, F=Cleared, G=Deposit Amount, H=Balance

I've been play with the sumif commands and I'm at a lost. Please help.
Thanks!
 
R

Roger Govier

Hi

I'm not sure where Cleared comes in to your scenario, but ignoring that
for the moment.
Assuming that H2 contains the opening balance on the account.
In H3
=H2+G3-(D3*(E3="x"))
 
Top