help with formulating a calculation

L

LuAnne 1

I need to multiply A2 against the entire row of 2, b thru k. I would be
greatful for the help.
 
S

Shane Devenshire

Hi,

Select cell A2 and do copy.

Select B2:K2 and choose Edit, Paste Special, Multiply.

If on the other hand you wanted the results somewhere else you could write
=$A$2*B2 and copy it to the right.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
VBA group the number in the Column and Copy to the new worksheet. 0
Cell Formulation 5
Excel Complex Summing 3
Countif 3
Formulating dates by weeks 4
Avoiding answer zero by multiply 4
Reducing repetitive calculation not working 1

Top