Thread: recursive sums
View Single Post
  #7   Report Post  
Hans Knudsen
 
Posts: n/a
Default

Just to add one mo
Put n (= number of terms of the sequence f(x)) in A1 and x in A2 then enter the following array formula:
=1+SUM((FACT((ROW(INDIRECT("1"&":"&A1))))^-1)*A2^ROW(INDIRECT("1"&":"&A1)))
(Note that n 21 will not change the result).

Hans Knudsen


"Joe" skrev i en meddelelse ...
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.