Exponential Series
"BobK" wrote:
I know how to use Autofill to fill in series, but wanted the
values to grow exponentially. Can this be done with formulas
or just numbers? For example, if A1 contains =3^1, A2
contains =3^2, A3 contains =3^3, and so on
I don't know if this can be done with Autofill or similar operation. I
would use the following formula, starting in A1 and copying down:
=3^(row()-row($A$1)+1)
Alternatively, treat A1 as a special case, and put the following formula in
to A2 and copy down:
=3^(row()-row($A$1))
----- original message -----
"BobK" wrote in message
...
I know how to use Autofill to fill in series, but wanted the values to grow
exponentially. Can this be done with formulas or just numbers? For
example,
if A1 contains =3^1, A2 contains =3^2, A3 contains =3^3, and so on, can
Fill
Series keep the series growing?
Or if I type 3, then 9, then 27 versus formulas, could that grow
exponentially?
Thanks in advance!
|