long@mcntsh.enet.dec.com (Rich Long) (01/29/91)
I'm trying to simulate a check book in Excel, and have run into a problem with
determining the uncleared balance. I have two columns:
Cleared Amount
---------------------
X 20.00
40.00
X 10.00
... ...
What I need is a formula for the uncleared balance cell that will add to the
balance only if the "cleared" column is blank. It should also automatically
account for new transactions added to the bottom of the columns. I have a
feeling I need a macro for this, but I'm having trouble figuring out how to
do it. I'd appreciate it if someone could send me some sample
code/suggestions.
Thank you!
Richard C. Long * long@mcntsh.enet.dec.com
* ...!decwrl!mcntsh.enet.dec.com!long
* long%mcntsh.dec@decwrl.enet.dec.com