newbie needs help please

[Nadia]

I have 3 columns, A: is a column multiplyer, B: is a column of different
numbers, C: a column of the answers ( B*A)
example
A1: 10 B1: 200: C1= 2000 the B: column B1:b100 has approx 100 rows of
varyng amounts I need to just change the multipler in the A column and the
answers will come out into the C: column
I can't get it to work on all the numbers, If I enter a formula in C1 it
will only give me an answer for that row, I need a formula to work out all
the different numbers in the b column and see the answers in the C column
when entering a different multiplyer in A column
I hope I have explained it correctly can anyone help, I am sure it is easy
but I can't do it.

TIA
Nadia

 

[Frank Kabel]

Hi
in C1 try
=$A$1*B1
and copy this down

 

[duane]

it sounds like all of column b is multiplied by the same value. if so
you can make the column c formulas =$a$1*b1 (in cell c1) and copy thi
down column c. whenever you change the value in cell a1, all th
results in column c will change

 

[Nadia]

Thank you very much, you mananged to decypher my text and you have solved
my problem

Thanks