View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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?