openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <b.m.bar...@btinternet.com>
Subject Re: Calc: Easy way to do N+(N-1)+(N-2)+(N-3)..(N-N+1)
Date Fri, 21 Jun 2013 18:37:14 GMT
At 18:27 21/06/2013 +0000, Jonathon 'Toki' Kantoor wrote:
>Is there a formula, extension, or something in calc that enables one 
>to calculate the sum of 1..N, where N is an integer between 0 and 100 000 000?

Yes.  Sigma (1 to n) is n(n+1)/2.

>If so, what is the formula, extension, or something?

=Xn*(Xn+1)/2

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message