checkbook reconciliation, how to.

[dave c]

Hello,
I've made an excel checkbook register. I think I need to write an IF, AND, OR statements, but am having a very tough time trying to get it to work. Please see attached file for a reference.

cell E9 = withdrawals
cell F9 = deposits
cell G9 = balance
cell H9 = reconciled (1) = green check, (0) = red "X" meaning cleared by the bank and not cleared by the bank
cell I9 = running balance (what's actually in the account once items have cleared from cell "H"

what I'd like to do is every time I change any cell "H" to a green check mark, I'd like the run an actual balance to reflect what money is in the account. Any help on this would be greatly appreciated!! Thank you so much.

[6StringJazzer]

Welcome to the Forum dave c!

You will get better responses if you attach an Excel file instead of a Word file with a picture of an Excel file.