Excel help needed with checkbook sheet

Article View: comp.sys.mac.apps

Article #6991

#6991

From: Rich Long
Date: Tue, 29 Jan 1991 15:46

23 lines
1271 bytes

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

Technical Details

Message-ID: <19555@shlump.nac.dec.com>

Path:

arc1-ca.pugleaf.net!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

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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