Thread: recursive sums
View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

=FACT(ROW(A1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JMB" wrote in message
...
For you first question

If you are starting in cell A1:

=FACT(ROWS(A$1:A1))

and copy down.

"Joe" wrote:

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.