PDA

View Full Version : o/t excel assistance



davidh
01-28-2010, 12:36 PM
someone quite a while back showed how to make excel do a run of numbers down the "a" column adding the first number to each number as it goes down the column. . . starting with 1.5 and adding that to the second number for the third, etc. . . . 1.5, 3, 4.5, 6 etc to reach 360. . . . for scribing marks on my new wheel on my rotab.
would they please enlighten me again. . its too much to do by hand for this old dude. .

thanks very much.

Mcgyver
01-28-2010, 12:42 PM
enter 1.5 in cell A1
enter the following in A2: =A1+1.5
click on A2.
with the mouse grab the little square corner (click and hold) of the box around the cell and drag in down, this copies the foruma down as many you'd like

Tony Ennis
01-28-2010, 12:47 PM
or, put '0' in row 1, '1.5' in row 2, select both, then grab the little handle that appears in the lower right and drag it down the page.

or, put '1.5' in A1, and =a1+$A$1 in A2. Select A2 and drag it down. The '$' signs mean 'absolute reference' and are useful for colunm and row values when making tables. On row 10, the formula will be something like =A9+A1.

davidh
01-28-2010, 12:57 PM
awsome ! i did it.

THANK YOU'SE !