how can I multiply a column by only one cell?

[Douglas Rivera]

how can I multiply a column by only one cell? I need to use the information in one sell to multiply cells in one column.

a b
2.5 9.0
3.5
2.8
8.4

ie, multiply cells in a by the cell in b.?

 

[Stan Brown]

how can I multiply a column by only one cell? I need to use the
information in one sell to multiply cells in one column.

a b
2.5 9.0
3.5
2.8
8.4

ie, multiply cells in a by the cell in b.?

Edit » Paste Special will do it. Or do you want a formula to place
in say C1:C4? In that case, put
=A1*B$1
in C1, and drag down to fill C2 through C4. A1 will change to A2,
A3, A4 but B$1 will not change.

Your textbook should cover this under "absolute references".

 

[GS]

Stan,
Your solution does not address the OP's requirement of an absolute ref
to the cell containing the multiplier! It only contains an absolute ref
to the row where the cell is located. This will change if the formula
needs to span columns that also must use an absolute ref to the cell
containing the multiplier.

Suggested formula:

=A1*$B$1

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Stan Brown]

Your solution does not address the OP's requirement of an absolute ref
to the cell containing the multiplier! It only contains an absolute ref
to the row where the cell is located. This will change if the formula
needs to span columns that also must use an absolute ref to the cell
containing the multiplier.

Of course it will, but the example given showed numbers in a column
only. I didn't want to complicate the answer to the OP's homework,
so I tailored my answer to the problem as presented.

I do agree that your answer, using $B$1, would also work in that
situation, and would work in other situations as well.

 

[Salmon Egg]

how can I multiply a column by only one cell? I need to use the information
in one sell to multiply cells in one column.

a b
2.5 9.0
3.5
2.8
8.4

ie, multiply cells in a by the cell in b.?

It is possible to use past spacial to dow the job.

Copy the 9.0.
Select the range from 2.5 to 8.4.
Use Paste Special.
Select the multiply radio button.
Press OK.

If you do not wish to modify the column, first it to say column c.

Sam

--

Sam

Conservatives are against Darwinism but for natural selection.
Liberals are for Darwinism but totally against any selection.