multiply by no. in cell

  • Thread starter Thread starter shlomo
  • Start date Start date
S

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
 
I don't understand the problem. Can you give a bit more information?
So i can help
 
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
 
Back
Top