formula for checkbook
Perhaps
=H6+G7-D7*(E7="X")
"ygl" wrote:
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!
|