Exponential Series

[BobK]

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!

 

[JoeU2004]

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

 

[Gord Dibben]

=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

 

[JoeU2004]

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