multiply by no. in cell

[shlomo]

I would like to know if its possible that information that I have i
cells B1, C1, should multiply by the no. that I have in cell A1
(A1=5,) I would like to have five times the info. from cells B1 and C

 

[Petrus Van den Cruyce]

I don't understand the problem. Can you give a bit more information?
So i can help

 

[Gord Dibben]

shlomo

=B1*A1 entered in B2(helper cell) or wherever.

If you don't want a helper cell, just copy A1 and select B1 and C1 then Paste
Special>Multiply>OK>Esc.

Gord Dibben Excel MVP