Beginner(formulas?)

N

nomad31

Hey..im doing this add math project of mine and im really new to
microsoft excel.
Lets say i have the numbers 1 - 10 in column A, and i have to count
them using the sum 4.2+2X (X representing the respective numbers in A).
WHat formula do i have to use? and how do i duplicate the same formula
for each of these numbers.

eg:
A B
1 4.2+2(1) = 6.2
2 8.2
3 10.2
4 12.2
5 14.2
6 16.2
7 18.2
8 20.2
9 22.2
10 24.2

the thing is, the question requires me to do the same thing for a
hundred numbers..and its a tougher sum..so i need help..thanx
 
P

Paul Sheppard

nomad31 said:
Hey..im doing this add math project of mine and im really new t
microsoft excel.
Lets say i have the numbers 1 - 10 in column A, and i have to coun
them using the sum 4.2+2X (X representing the respective numbers in A)
WHat formula do i have to use? and how do i duplicate the same formul
for each of these numbers.

eg:
A B
1 4.2+2(1) = 6.2
2 8.2
3 10.2
4 12.2
5 14.2
6 16.2
7 18.2
8 20.2
9 22.2
10 24.2

the thing is, the question requires me to do the same thing for
hundred numbers..and its a tougher sum..so i need help..thanx
Click to expand...

Hi nomad31

Try =Sum(A1*2)+B1 in column C

To copy this to other cells, click on the cell with the formula in
there will be a black box bottom right corner of the cell, move th
cursor ober this it will change to a black cross, double click with th
left mouse button and the formula will copy right down the colum
 
Top