Article View: comp.sys.amiga.applications
Article #13861Re: TurboCalc
From: Herbert Wollman
Date: Fri, 19 Apr 1996 18:16
Date: Fri, 19 Apr 1996 18:16
33 lines
1279 bytes
1279 bytes
From: Herbert Wollman hwollman@mitre.org In article <4l877f$eug@news.tiac.net>, dmeyer@tiac.net (David Meyer) wrote: > Uwe Sigurd Valentin Kubosch (uwek@isleiv.ifi.uio.no) wrote: > : I need a field to be calculated as the cumulative sum of another > : field like this: > : > : Field1 Field2 > : > : 1 1 > : 2 3 > : 3 6 > : 4 10 > : > : Except for a zillion if(;;)'s, is there a way to do this in > : TurboCalc? > : > Hmmm, the first part is easy enough: SUM > > A B > 1 1 1 > 2 2 3 > 3 3 6 > > (you forgot the grid) The formula in B2 should be SUM(A$1:A2). Then copy > this down the B column. The "A2" will increase by one at every row, the > "A$1" will stay the same. An faster alternative is; B1 = A1 B2 = A2+B1 copy B2 down into the rest of the range.
Technical Details
Message-ID:
<hwollman-1904961516410001@hwollman.mitre.org>Path:
arc1-ca.pugleaf.net!hwollman.mitre.org!userReferences:
<w1gu3yg7krl.fsf@isleiv.ifi.uio.no> <4l877f$eug@news.tiac.net>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!hwollman.mitre.org!user From: hwollman@mitre.org (Herbert Wollman) Newsgroups: comp.sys.amiga.applications Subject: Re: TurboCalc Date: Fri, 19 Apr 1996 15:16:41 -0300 Organization: Mitre Corp. Message-ID: <hwollman-1904961516410001@hwollman.mitre.org> References: <w1gu3yg7krl.fsf@isleiv.ifi.uio.no> <4l877f$eug@news.tiac.net> NNTP-Posting-Host: hwollman.mitre.org