View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default multiplying everything in line A X 50 = results in Line B

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.


"benjamin" wrote:

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