multiplying everything in line A X 50 = results in Line B

[benjamin]

I have hours in Line A, and Need the code to multiply by 50/hr and have the
results in Line B

 

[Newbeetle]

If say you have the number 20 in cell A1 and in B1 you want your answer type
=A1*50
you will have the answer.

You can then drag B1, down as far as you need it, and the ref A1 will change
to A2, A3 and so on.

 

[JLatham]

Assuming your hours start in A1, put this in B1
=A1*50
select cell B1 again and move your cursor to the lower-right corner of B1
until it turns into a small + sign and then double-click, the formula will
fill down in all cells in B adjacent to a value in A.

 

[Max]

Assuming data in A2 down,
Put in B2: =A2*50
Copy B2 down as far as required by dragging the fill handle (the solid
square at the bottom right corner of the cell).

 

[MartinW]

Hi Benjamin,

You say your values in A1 are in hours so try in B1 =A1*50*24
and format the cell to general.

HTH
Martin