O
Old Red One
Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68.
How to write formula?
How to write formula?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
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.
the 2 cells and fill down as appropriate.
Another way is to put =17*ROWS($1:1) in the first cell and fill down.
T
T. Valko
Enter 17 in A1 and 34 in A2.
Select both A1 and A2 then drag down as needed.
Select both A1 and A2 then drag down as needed.
C
Clarence Crow
if you anchor your 17 (or any other number) near the top of a column,Need table showing progression of 17 from base 17; i.e., 17, 34, 51, 68.
How to write formula?
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
G
Gord Dibben
Enter 17 in A1
In A2 enter =$C$1 + C1
Copy down.
Gord Dibben MS Excel MVP
In A2 enter =$C$1 + C1
Copy down.
Gord Dibben MS Excel MVP
D
David Biddulph
Minor correction:
For =$C$1 + C1 read =$A$1 + A1
For =$C$1 + C1 read =$A$1 + A1
G
Gord Dibben
Now just where did the "C's" come from? <g>
Or maybe the typos were the "A's"?
Thanks David
Or maybe the typos were the "A's"?
Thanks David