Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!think.com!mintaka!bloom-beacon!deccrl!news.crl.dec.com!shlump.nac.dec.com!mcntsh.enet.dec.com!long
From: long@mcntsh.enet.dec.com (Rich Long)
Newsgroups: comp.sys.mac.apps
Subject: Excel help needed with checkbook sheet
Message-ID: <19555@shlump.nac.dec.com>
Date: 29 Jan 91 15:46:37 GMT
Sender: newsdaemon@shlump.nac.dec.com
Organization: Digital Equipment Corporation
Lines: 23


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