View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Excel Calculations

Look in help at the difference between absolute and relative addressing.
--
David Biddulph

Bill R wrote:
I have a series of variable values in one column. I also have a fixed
value in one cell. I want to multiply all of the variable values by
the fixed value. How do I copy the formula for one calculation down
the entire adjacent column without Excel changing the cell number
that contains the fixed value.