Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula setup
Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68.
How to write formula? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula setup
One way is to type 17 in the first cell, 34 in the second cell, then select
the 2 cells and fill down as appropriate. Another way is to put =17*ROWS($1:1) in the first cell and fill down. -- David Biddulph "Old Red One" wrote in message ... Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68. How to write formula? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula setup
Enter 17 in A1 and 34 in A2.
Select both A1 and A2 then drag down as needed. -- Biff Microsoft Excel MVP "Old Red One" wrote in message ... Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68. How to write formula? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula setup
On Thu, 28 Feb 2008 15:05:02 -0800, "Old Red One"
wrote: Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68. How to write formula? if you anchor your 17 (or any other number) near the top of a column, say B5 and in the row cell below in the same column enter =B5, you can then simply drag down column B as far as you wish to go. I have several bank account statements set similarly. -Please reply to group as my email addr is fake! -Regards CC |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula setup
Enter 17 in A1
In A2 enter =$C$1 + C1 Copy down. Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 15:05:02 -0800, "Old Red One" wrote: Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68. How to write formula? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula setup
Minor correction:
For =$C$1 + C1 read =$A$1 + A1 -- David Biddulph "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Enter 17 in A1 In A2 enter =$C$1 + C1 Copy down. Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 15:05:02 -0800, "Old Red One" wrote: Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68. How to write formula? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula setup
Now just where did the "C's" come from? <g
Or maybe the typos were the "A's"? Thanks David On Fri, 29 Feb 2008 08:07:59 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: Minor correction: For =$C$1 + C1 read =$A$1 + A1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with Hyperlink formula setup | Excel Discussion (Misc queries) | |||
Formula setup / OFFSET problem | Excel Discussion (Misc queries) | |||
How do I setup a formula to insert the rate? | Excel Worksheet Functions | |||
How do I set a date formula in the page setup header to add 10 | Excel Discussion (Misc queries) | |||
how to setup formula? | Excel Worksheet Functions |