P

#### 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