Cell reference

M

MS

I have the following calculation to perform, with one cell being the same in
all calculations.

A1*B1 = C1
A1*B2 = C2
A1*B3 = C3

How can I do so without typing the value of A1 three time?. I think there's
a way to do so using $ sign, but am unable to do it.

Thanks
 
M

Marcelo

=A$1*b1

and copy down

to fix the column use a $ before letter and to fix the row before the number

HTH
Regards from Brazil
Marcelo

"MS" escreveu:
 
D

David Biddulph

MS said:
I have the following calculation to perform, with one cell being the same
in
all calculations.

A1*B1 = C1
A1*B2 = C2
A1*B3 = C3

How can I do so without typing the value of A1 three time?. I think
there's
a way to do so using $ sign, but am unable to do it.
Click to expand...

=A$1*B1

[Look up absolute & relative addressing in Excel's help.]
 
M

Marcelo

thanks for the feedback and belive we also hope, but it isn't easy.. ;o)


"MS" escreveu:
 
Top