Forum Discussion
Solved
Increase the value of a column of cells by a fixed number into new cells
I have a column of cells that contain prices and what I want to do is apply to each cell in the column a percentage increase. I can apply a formula to increase the value and put the result into a...
- As long as your formula is linked to the original cell, it updates every time to change or in your case delete the value. You could copy the result of your formula and paste as values, then it wouldn't be linked to the original cell anymore, would that work for you?
https://support.office.com/en-us/article/paste-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9
As long as your formula is linked to the original cell, it updates every time to change or in your case delete the value. You could copy the result of your formula and paste as values, then it wouldn't be linked to the original cell anymore, would that work for you?
https://support.office.com/en-us/article/paste-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9
https://support.office.com/en-us/article/paste-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9
PascalKTeamJust tried it. As you suggested, I needed to do it in two steps to just get the values without the formula.
Thanks for the tip!
- OK I'm glad this works for you. If you could mark my post as "official answer" that would be nice, thanks