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!

"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!

=3^ROW(1:1) and copy down will satisfy the first scenario.

The second scenario is not possible with just the numbers as you posted.


Gord Dibben MS Excel MVP

On Thu, 26 Mar 2009 11:39:02 -0700, 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, 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!

"Gord Dibben" <gorddibbATshawDOTca wrote:
=3^ROW(1:1) and copy down will satisfy the first scenario.

Nah, that's too easy. Dontcha get paid by the number of keystrokes? :-)
Klunk!