ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   making a sum of a eq. with a var running form 0-infinity. (https://www.excelbanter.com/excel-discussion-misc-queries/89266-making-sum-eq-var-running-form-0-infinity.html)

silverspace

making a sum of a eq. with a var running form 0-infinity.
 
How do I make a sum of the result from a eq. with a var (n) running from 0 -
infinity?

Gary''s Student

making a sum of a eq. with a var running form 0-infinity.
 
You are in luck:

Because of Excel's use of the IEEE standard for number representation, any
convergent infinite series can be exactly represented in Excel by a finite
set of terms (any additional terms being so small that they do not change the
result).

Put the set of partial sums in a column and stop when the sum stops changing.
--
Gary's Student


"silverspace" wrote:

How do I make a sum of the result from a eq. with a var (n) running from 0 -
infinity?



All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com