Thread: recursive sums
View Single Post
  #5   Report Post  
Dana DeLouis
 
Posts: n/a
Default

Hi. Just to add....
In A1, you could enter this for the first part of the equation.
=1/FACT(ROW()-1)

and drag down to say A10. (ie Start w/ Fact(0) )

Then your Series can be calculated as...

=SERIESSUM(1,0,1,A1:A10)

Returns a number close to =EXP(1)
HTH :)
--
Dana DeLouis
Win XP & Office 2003


"Joe" wrote in message
...
I would like to know how to generate a column which can fill the cells in
the
order: FACT(1) ; FACT(2); FACT(3)... etcetera. Apparently it will not work
by
dragging the cells down.

Also, I need to generate a cell which can perform the function of:
f(x) = e^x = 1 + (1/1!)*x + (1/2!)*x^2 + (1/3!)*x^3... which by means is
the
exp fn of the maclaurin series.

any help or suggestions is very much appreciated.