Stop Formula reference from applying to whole column/sheet

Mar_star

Hello,

I have a formula I am trying to apply to only certain cells. See below:

=IF(ISNUMBER([Column15]@row), IF([Column15]@row >= {LL5}, "5", IF([Column15]@row >= {LL4}, "4", IF([Column15]@row >= {LL3}, "3", IF([Column15]@row >= {LL2}, "2", "1")))), " ")

Then I want to copy and paste this formula to a different cell on the same column but change the "reference" these pieces {LL5}

But when I try to do that it changes the whole column to the new reference, how can I stop this from happening?

I have tried changing the name of my reference, adding a different column for the new formula but it still changes all the formula on the whole sheet. What am I missing here? I can do this with other formulas in my "matrix sheet but not this one.

Paul Newcome

You would need to create a new reference instead of editing the existing reference.