Fill 1, 2, 3, 5, 8, 13, 21, 34
 

I would like to create a fill series where the next cell adds the values in
the previous two (2) cells. Any ideas? Thanks.

Fill 1, 2, 3, 5, 8, 13, 21, 34
 

Put 0 in A1.
Put 1 in A2.
put =a1+a2 in A3.
Select a3 and drag down as far as you want


Kokomojo wrote:

I would like to create a fill series where the next cell adds the values in
the previous two (2) cells. Any ideas? Thanks.

--

Dave Peterson

Fill 1, 2, 3, 5, 8, 13, 21, 34
 

I guess that it's a "given", that you must start the series by entering the
*first* 2 values.

So, with 2 values in A1 and A2, enter this in A3, and copy down as needed:

=A1+A2
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Kokomojo" wrote in message
...
I would like to create a fill series where the next cell adds the values in
the previous two (2) cells. Any ideas? Thanks.

Fill 1, 2, 3, 5, 8, 13, 21, 34
 

Thanks Dave, I was just wondering if you could do it with any of the fill
commands (Edit Menu, Fill, Series). Thanks for replying. This will be a
good work-around.

"Dave Peterson" wrote:

Put 0 in A1.
Put 1 in A2.
put =a1+a2 in A3.
Select a3 and drag down as far as you want


Kokomojo wrote:

I would like to create a fill series where the next cell adds the values in
the previous two (2) cells. Any ideas? Thanks.

--

Dave Peterson