Adjusting values to a new percentage

%3CLINGO-SUB%20id%3D%22lingo-sub-3002360%22%20slang%3D%22en-US%22%3EAdjusting%20values%20to%20a%20new%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3002360%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20set%20of%20data%20(in%20percentage)%20and%20I%20had%20to%20change%20the%20based%20assumed%20percentage%20to%20a%20new%20one%20how%20to%20adjust%20this%20new%20percentage%20for%20the%20rest%20of%20my%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20guys%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3002360%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-3002579%22%20slang%3D%22en-US%22%3ERe%3A%20Adjusting%20values%20to%20a%20new%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3002579%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F57080%22%20target%3D%22_blank%22%3E%40Sara%20Kaffashi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20also%20be%20an%20advantage.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20to%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20always%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFinally%2C%20here%20is%20a%20link%20with%20information%20on%20how%20you%20can%20get%20a%20quick%20and%20precise%20solution%20proposal.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a set of data (in percentage) and I had to change the based assumed percentage to a new one how to adjust this new percentage for the rest of my data.

 

Thanks guys

4 Replies

@Sara Kaffashi 

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster. Knowing the Excel version and operating system would also be an advantage.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not always in the case of Excel, on the contrary in some cases.

 

Finally, here is a link with information on how you can get a quick and precise solution proposal.

 

Welcome to your Excel discussion space!

 

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE 

Thanks, I have a 33% on the previous page and in the excel sheet that I am attaching I want to simply put a formula that in every cell be like e2*(33/49.5)

SaraKaffashi_0-1637783181674.png

 

@Sara Kaffashi I would give the cell on "the previous page" that contains the 33% a name, for instance perc and than use adapt the formula to: =E2*(perc/49.5)

 

More about creating named ranges in the link below:

https://support.microsoft.com/en-us/office/create-a-named-range-from-selected-cells-in-a-worksheet-f... 

Thanks a lot Riny. I did the calculation and the results are perfect...you made my life easy