Just to add one more:
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" <Joe@discussions.microsoft.com> skrev i en meddelelse news:2253F0CA-54C6-45BC-B86A-06CC1684705E@microsoft.com...
>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.