Add percent on multiply numbers in excel automaticly

%3CLINGO-SUB%20id%3D%22lingo-sub-2242399%22%20slang%3D%22en-US%22%3EAdd%20percent%20on%20multiply%20numbers%20in%20excel%20automaticly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2242399%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20using%20the%20formula%20below%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fmultiply-by-a-percentage-b7485923-00c1-4d2c-b567-d74d568c4e8f%3Fui%3Den-US%26amp%3Brs%3Den-GB%26amp%3Bad%3DGB%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fmultiply-by-a-percentage-b7485923-00c1-4d2c-b567-d74d568c4e8f%3Fui%3Den-US%26amp%3Brs%3Den-GB%26amp%3Bad%3DGB%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIm%20using%20the%20bottom%20formula%3A%3C%2FP%3E%3CP%3EMultiply%20an%20entire%20column%20of%20numbers%20by%20a%20percentage%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20when%20i%20do%20this%20the%20only%20number%20that%20is%20showing%20is%20the%20percent%20it%20has%20increased%2C%20not%20the%20complete%20number%3A%20Eg%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.96%20%2B%2025%20%25%20%3D%202%2C45.%3C%2FP%3E%3CP%3E25%20%25%20increase%20is%200%2C49.%3C%2FP%3E%3CP%3E1.96%20%2B%200%2C49%20%3D%202.45%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20the%20only%20number%20that%20is%20showing%20in%20my%20excel%20columns%20is%200%2C49%2C%20not%20the%20total%20new%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20solve%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2242399%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Im using the formula below:

https://support.microsoft.com/en-gb/office/multiply-by-a-percentage-b7485923-00c1-4d2c-b567-d74d568c...

 

Im using the bottom formula:

Multiply an entire column of numbers by a percentage

 

My problem is that when i do this the only number that is showing is the percent it has increased, not the complete number: Eg:

 

1.96 + 25 % = 2,45.

25 % increase is 0,49.

1.96 + 0,49 = 2.45

My problem is that the only number that is showing in my excel columns is 0,49, not the total new number.

 

How do i solve this issue?

 

 

4 Replies

@excelingdan 

As the article you refer to mentions, if you want to increase a number by 25% (instead of multiply a number with 25%), you have to use a formula such as =1.96*(1+25%)

You can use cell references instead of literal numbers, of course, e.g. =A2*(1+25%)

@Hans Vogelaar 

Ok, but how do i do that in excel, show me thanks.

I do this now:

i write 25 % i a column, copy paste that and then mark all the numbers in the excel file that i want to increase with 25%. then i rihght click on the nukmbers i want to increase, choose paste in special and then i choose value and multiply and all the numbers change but only the percent increase not the total new number.

@excelingdan 

Increasing by 25% means that the new value is 100% of the old value + 25% of the old value, so 125% of the old value. In other words, you have to multiply with 125%, not 25%.

So you should enter 125% in an empty cell, then proceed as before.

@Hans Vogelaar 

I dont know how but it works!

Thanks a bunch.