P
Paul Schrum
I am an intermediate Excel end user.
Is there a way to enter a cell formula once, then have other cells in
lower rows (but the same column) refer to the "head" cell's formula as
if it were in the same row?
Sorry this description is so convoluted, but I this is the best I can
think of. Let me restate for clarity. I have non-tabular
information in rows 1-3. Row 4 contains column labels. Rows 5 and
lower contain data (in some columns) and formulas (in other columns).
For any given column, I would like to be able to enter the formula
once in Row 5. Then enter some other function in Rows 6 and lower
which would redirect to the formula in Row 5, except row numbers for
relative cell references are updated as if I had done a copy/paster
operation. If this function were named referenceFormula(), then cells
A5 through A7 would look like this:
Cell_ID: Formula As Entered: Actual Formual Behavior:
A5 =B5*$A$2+C5 =B5*$A$2+C5
A6 =referenceFormula(5) =B6*$A$2+C6
A7 =referenceFormula(5) =B7*$A$2+C7
The great advantage of this is that I could make a change to a formula
in the "base row" and not have to copy/paste or autofill the change
back down to all the other rows.
Thanks in advance to anyone who responds.
- Paul Schrum
Is there a way to enter a cell formula once, then have other cells in
lower rows (but the same column) refer to the "head" cell's formula as
if it were in the same row?
Sorry this description is so convoluted, but I this is the best I can
think of. Let me restate for clarity. I have non-tabular
information in rows 1-3. Row 4 contains column labels. Rows 5 and
lower contain data (in some columns) and formulas (in other columns).
For any given column, I would like to be able to enter the formula
once in Row 5. Then enter some other function in Rows 6 and lower
which would redirect to the formula in Row 5, except row numbers for
relative cell references are updated as if I had done a copy/paster
operation. If this function were named referenceFormula(), then cells
A5 through A7 would look like this:
Cell_ID: Formula As Entered: Actual Formual Behavior:
A5 =B5*$A$2+C5 =B5*$A$2+C5
A6 =referenceFormula(5) =B6*$A$2+C6
A7 =referenceFormula(5) =B7*$A$2+C7
The great advantage of this is that I could make a change to a formula
in the "base row" and not have to copy/paste or autofill the change
back down to all the other rows.
Thanks in advance to anyone who responds.
- Paul Schrum