Quick answer please!

[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

 

[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.

 

[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

 

[JE McGimpsey]

One way:

A1: =(40-ROW())*25.64

Copy down to A39

 

[R.P.McMurphy]

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

Wow, so simple. and so quick!

Cheers!

Steve

 

[Guest]

The sum of the first 39 numbers is n*(n+1)/2
You could have type in 39*40/2*25.64