TurboCalc

Thread View: comp.sys.amiga.applications

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Uwe Sigurd Valentin Kubosch Fri, 19 Apr 1996 07:09

#13840

Author: Uwe Sigurd Valentin Kubosch
Date: Fri, 19 Apr 1996 07:09

27 lines
1333 bytes

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?

All help is greatly appreciated.


donV
-- 
Uwe S.V. Kubosch        Milron Data             Crusaders Productions       
Stavikbakken 3          Johan Svensens vei 2a   Stasjonsveien 56            
N-1472 Fjellhamar       N-1472 Fjellhamar       N-2010 Strømmen             
Norway                  Norway                  Norway                      
Phone:+47 67 90 11 95   Phone:+47 67 90 95 24   Phone:+47 63 80 33 24       
Phone:+47 92 20 60 46                           Phone:+47 63 80 00 53 (ISDN)
                                                Phone:+47 92 20 60 63       
    Web:<http://www.ifi.uio.no/~uwek/>          Fax  :+47 63 80 00 54 (ISDN)
   Crusaders:<http://www.crusaders.no/>         BBS  :+47 22 10 46 46

Re: TurboCalc

#13845

Author: David Meyer
Date: Fri, 19 Apr 1996 14:16

24 lines
944 bytes

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.

Re: TurboCalc

#13861

Author: 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.

Re: TurboCalc

#13889

Author: Owen James
Date: Sun, 21 Apr 1996 14:22

21 lines
854 bytes

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?

Very simple. In this case, B1 should just equal A1. The formula you need is
B2=B1+A2. Then just highlight the length of the column you wish to have this
formula apply to and select `fill'. Simple as that.

Cheers,

OJ.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads