Dragging cells

  • Thread starter Thread starter Tommy
  • Start date Start date
T

Tommy

I'm trying to use a formula to calculate values into a column and they
require the values directly to the left of them to be divided by a single
cell. So the numerator will be a new number each row down, but the
denominator needs to be the same cell. I was wondering how to tell all the
cells in the column to use that same reference cell instead of having each
successive row use the next row down under the reference.
 
=A1*$C$1

The $ makes the reference absolute, not relative when you copy the formula.
ie $C$1 is always C1. $C1 is always column C but the row can vary. Likewise
C$1 the column can vary but will always be row 1.
 
Back
Top