making a sum of a eq. with a var running form 0-infinity.

S

silverspace

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

Gary''s Student

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.
 
Top