Won't that throw an error if the first row or column is deleted (assuming the
table does not start in cell A1)?


"Bob Phillips" wrote:

> =FACT(ROW(A1))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "JMB" <JMB@discussions.microsoft.com> wrote in message
> news:A6B79BD9-3333-4FFF-91E9-1263010B8C6C@microsoft.com...
> > 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.
>
>
>