Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) |