🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.amiga.applications
Article #13861

Re: TurboCalc

#13861
From: Herbert Wollman
Date: Fri, 19 Apr 1996 18:16
33 lines
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!user
References: <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