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

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.
--
This post was created using recycled electrons!


"benjamin" wrote:

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