formula for checkbook

G

Guest

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"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top