View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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!