G
Guest
I have hours in Line A, and Need the code to multiply by 50/hr and have the
results in Line B
results in Line B
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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.
=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.
G
Guest
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.
=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.
G
Guest
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).
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).
M
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
You say your values in A1 are in hours so try in B1 =A1*50*24
and format the cell to general.
HTH
Martin