Forum Discussion
Add percent on multiply numbers in excel automaticly
Im using the formula below: https://support.microsoft.com/en-gb/office/multiply-by-a-percentage-b7485923-00c1-4d2c-b567-d74d568c4e8f?ui=en-US&rs=en-GB&ad=GB Im using the bottom formula: Multipl...
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.
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.