dragging formulas across rows

  • Thread starter Thread starter JB Akron
  • Start date Start date
J

JB Akron

Hello - I have a number in one cell (D2) that I need to use as a constant
value (in the denominator) to create proportions (E2/D2, F2/D2, G2/D2, etc..)
across Row 3 -E3-FS3). The drag feature will not keep D2 selected in the
denominator in subsequent cells. Instead, it creates (E2/D2, F2/E2, G2/F2,
etc..). Any possible solutions?
 
Use
=E2/$D2
and drag across

$ will keep D2 constant in the current row...
It will change to D3 in the next row below. If you don't want that then try
=E2/$D$2
 
Back
Top