Quick answer please!

R

R.P.McMurphy

To a simple question.

I need the answer to the following calculations quick.

39 * 25.64 =
38 * 25.64=
................
................
..................
etc right down to 1 * 25.64=

Id be interested to see how you did this...other than manually using a
calculator for all 39 sums, I cant think of another way to do it!

Steve
 
R

Rick B

I would put 39 in A1, then 38 in A2, then use the drag tool to continue that
series all the way to A39.

In B1, I'd put = A1*25.64
Then in B2, I'd put =B2*25.64
etc.
Again, You can use the drag and fill tool so you don't have to type each
cell entry.
 
V

vezerid

Steve,
Type 1 in cell A1.
Type 2 in cell A2.
Select both.
Drag the selection from the small handle at the bottom right of the
selection border (your mouse pointer becomes a thin black rather than
the regular wide white cross whn on top of the handle). Drag until the
number 30.
In cell C1 enter 25.64
In B1 enter
=A1*$C$1
Copy down

HTH
Kostis Vezerides
 
R

R.P.McMurphy

vezerid said:
Steve,
Type 1 in cell A1.
Type 2 in cell A2.
Select both.
Drag the selection from the small handle at the bottom right of the
selection border (your mouse pointer becomes a thin black rather than
the regular wide white cross whn on top of the handle). Drag until the
number 30.
In cell C1 enter 25.64
In B1 enter
=A1*$C$1
Copy down

HTH
Kostis Vezerides
Click to expand...

Wow, so simple. and so quick!

Cheers!

Steve
 
Top