How to find and replace only part of a formula within a column without affecting the rest of the formula?

solved

Hi,

I have 2 columns. In the first, it is a series of numbers relating to costs in the year 2011. In the second column, I have the costs adjusted for inflation by 2015. I need to replace the inflation value in the second column without having it affect which cell I chose. Right now if I use find and replace, I can replace it with =T2*1.054 but then all the cells will basically be referenced on T2 rather than the cell in the column to the left. I can't click and drag because there are certain things that need to be preserved within the columns. Any tips? Thank you.

EDIT: For example, Column A has A1, A2, and A3. Column B has =A1 *1.088, A2 *1.088, A3 *1.088. I want to basically replace only the 1.088 in Column B with 1.054, such that A1 and A2 and A3 are not disturbed.

Posted Jul 16, 2017, 10:12 PM UTC · edited

2111
Loading comments…