dragging formulas across rows
 

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?

dragging formulas across rows
 

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


"JB Akron" wrote:

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?

dragging formulas across rows
 

It would be worth to have a look at this link to understand more on relative
and absolute references...

http://www.cpearson.com/excel/relative.aspx
--
If this post helps click Yes
---------------
Jacob Skaria


"JB Akron" wrote:

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?