View Single Post
  #1   Report Post  
Kirkwill
 
Posts: n/a
Default How to stop formulas from incrementing when you copy and paste?

I have a document that I want the column of cells that I selected to always
equal what I put in cell B2. It works in the first cell of the row, but then
it increments the formula below to read cell B3 and the next one B13 and so
on. What I am trying to do is have anywhere from 10 to 100 rows that
calculate number of hours worked by the dollar amount of a contract and that
amount changes for each client, so in my formula I tried having it look to
the cell B2 where I have that dollar amount, but the formula when copied
increments to b3, then b4 and so on.

Any info would be great thanks
Kirk