Change the address reference to absolute in the formula--a dollar sign in
front of the column letter, row number, or both, depending on which element
of the cell address you want to remain constant.

Same principle for filling right, as well.


"Pezcore" wrote:

=IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataIn put!D3="Recommended",R4+R4*Q4,0))

how do i reference a cell in a formula and not have it change all down the
columns?