SOLVED
Home

Increase the value of a column of cells by a fixed number into new cells

%3CLINGO-SUB%20id%3D%22lingo-sub-901122%22%20slang%3D%22en-US%22%3EIncrease%20the%20value%20of%20a%20column%20of%20cells%20by%20a%20fixed%20number%20into%20new%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901122%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20cells%20that%20contain%20prices%20and%20what%20I%20want%20to%20do%20is%20apply%20to%20each%20cell%20in%20the%20column%20a%20percentage%20increase.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20apply%20a%20formula%20to%20increase%20the%20value%20and%20put%20the%20result%20into%20an%20adjacent%20cell%20in%20an%20adjacent%20column%20but%20then%20what%20I%20want%20to%20do%20is%20delete%20the%20original%20column.%20However%20when%20I%20go%20to%20delete%20the%20original%20column%20of%20cells%2C%20the%20values%20in%20the%20new%20column%20of%20cells%20are%20lost.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20wondering%20how%20I%20can%20set%20this%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901122%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901266%22%20slang%3D%22en-US%22%3ERe%3A%20Increase%20the%20value%20of%20a%20column%20of%20cells%20by%20a%20fixed%20number%20into%20new%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901266%22%20slang%3D%22en-US%22%3EAs%20long%20as%20your%20formula%20is%20linked%20to%20the%20original%20cell%2C%20it%20updates%20every%20time%20to%20change%20or%20in%20your%20case%20delete%20the%20value.%20You%20could%20copy%20the%20result%20of%20your%20formula%20and%20paste%20as%20values%2C%20then%20it%20wouldn't%20be%20linked%20to%20the%20original%20cell%20anymore%2C%20would%20that%20work%20for%20you%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fpaste-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fpaste-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901304%22%20slang%3D%22en-US%22%3ERe%3A%20Increase%20the%20value%20of%20a%20column%20of%20cells%20by%20a%20fixed%20number%20into%20new%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901304%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3EJust%20tried%20it.%20As%20you%20suggested%2C%20I%20needed%20to%20do%20it%20in%20two%20steps%20to%20just%20get%20the%20values%20without%20the%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20tip!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901424%22%20slang%3D%22en-US%22%3ERe%3A%20Increase%20the%20value%20of%20a%20column%20of%20cells%20by%20a%20fixed%20number%20into%20new%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901424%22%20slang%3D%22en-US%22%3EOK%20I'm%20glad%20this%20works%20for%20you.%20If%20you%20could%20mark%20my%20post%20as%20%22official%20answer%22%20that%20would%20be%20nice%2C%20thanks%3C%2FLINGO-BODY%3E
cssaus
New Contributor

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 an adjacent cell in an adjacent column but then what I want to do is delete the original column. However when I go to delete the original column of cells, the values in the new column of cells are lost.

 

Just wondering how I can set this up.

 

Thanks.

3 Replies
Solution
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-947c229c5...

@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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies