Adding a percentage to a number and then subtracting the same percentage to get the same number

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
1
down vote

favorite












I wonder if you can help me?
I have found similar answers to this question but they don't seem to work.



I am after a formula or an excel formula so I can add a percentage to a number, then when I discount the same percentage off the larger figure I get back to exactly the same figure.



The reason for this is because I sell products at a price, some of my customers have special terms when they purchase so I add a percentage onto the selling price to cover these terms. Then when this percentage is discounted off the inflated cost, I need the selling total to go back to the original selling price.



For instance:
If I sell at £1.00,
Customer A has terms of 10%, so I need to add 10% onto 1.00, which is £1.10.
Then when I take 10% off £1.10, which is £0.11p, this returns to £0.99p, which is lower than my original selling price.



If anyone could help with a formula to explain the answer it would be amazing!
I would need the formula to work with different selling prices and different percentages.



Thanks in advance!
Adam







share|cite|improve this question

























    up vote
    1
    down vote

    favorite












    I wonder if you can help me?
    I have found similar answers to this question but they don't seem to work.



    I am after a formula or an excel formula so I can add a percentage to a number, then when I discount the same percentage off the larger figure I get back to exactly the same figure.



    The reason for this is because I sell products at a price, some of my customers have special terms when they purchase so I add a percentage onto the selling price to cover these terms. Then when this percentage is discounted off the inflated cost, I need the selling total to go back to the original selling price.



    For instance:
    If I sell at £1.00,
    Customer A has terms of 10%, so I need to add 10% onto 1.00, which is £1.10.
    Then when I take 10% off £1.10, which is £0.11p, this returns to £0.99p, which is lower than my original selling price.



    If anyone could help with a formula to explain the answer it would be amazing!
    I would need the formula to work with different selling prices and different percentages.



    Thanks in advance!
    Adam







    share|cite|improve this question























      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      I wonder if you can help me?
      I have found similar answers to this question but they don't seem to work.



      I am after a formula or an excel formula so I can add a percentage to a number, then when I discount the same percentage off the larger figure I get back to exactly the same figure.



      The reason for this is because I sell products at a price, some of my customers have special terms when they purchase so I add a percentage onto the selling price to cover these terms. Then when this percentage is discounted off the inflated cost, I need the selling total to go back to the original selling price.



      For instance:
      If I sell at £1.00,
      Customer A has terms of 10%, so I need to add 10% onto 1.00, which is £1.10.
      Then when I take 10% off £1.10, which is £0.11p, this returns to £0.99p, which is lower than my original selling price.



      If anyone could help with a formula to explain the answer it would be amazing!
      I would need the formula to work with different selling prices and different percentages.



      Thanks in advance!
      Adam







      share|cite|improve this question













      I wonder if you can help me?
      I have found similar answers to this question but they don't seem to work.



      I am after a formula or an excel formula so I can add a percentage to a number, then when I discount the same percentage off the larger figure I get back to exactly the same figure.



      The reason for this is because I sell products at a price, some of my customers have special terms when they purchase so I add a percentage onto the selling price to cover these terms. Then when this percentage is discounted off the inflated cost, I need the selling total to go back to the original selling price.



      For instance:
      If I sell at £1.00,
      Customer A has terms of 10%, so I need to add 10% onto 1.00, which is £1.10.
      Then when I take 10% off £1.10, which is £0.11p, this returns to £0.99p, which is lower than my original selling price.



      If anyone could help with a formula to explain the answer it would be amazing!
      I would need the formula to work with different selling prices and different percentages.



      Thanks in advance!
      Adam









      share|cite|improve this question












      share|cite|improve this question




      share|cite|improve this question








      edited Jul 26 at 9:34









      Especially Lime

      19.1k22252




      19.1k22252









      asked Jul 26 at 9:23









      AdamF

      82




      82




















          2 Answers
          2






          active

          oldest

          votes

















          up vote
          0
          down vote



          accepted










          You will need to modify the percentages. If you add $x%$ to a price $P$ then your new price is $Q=P+fracPx100$. You now want to subtract $fracPx100$ from $Q$, but that is $x%$ of $P$, not $x%$ of $Q$. As a proportion of $Q$, it is $$fracfracx1001+fracx100=fracx100+x,$$
          so this means that instead of subtracting $x%$ you need to subtract $y%$ of $Q$, where $$y=frac100x100+x.$$
          For example, if you added $10%$ you must subtract $frac1000110%=9.overline09%$.






          share|cite|improve this answer





















          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:43











          • No problem :) You need to subtract $frac1650116.5%$, which is about $14.164%$.
            – Especially Lime
            Jul 26 at 10:52










          • eeeek. So £1.56 * 1.165 = £1.8174p, which is 16.5% increase of £1.56. Then to deduct 16.5% from £1.8174 I need to subtract 14.164% from £1.8174? Doesn't that leave me with £1.5919203p ? I'm so confused haha
            – AdamF
            Jul 26 at 11:12

















          up vote
          0
          down vote













          If you take $99%$ off $€100$, you get $€1$. Then if you add $99%$ to $€1$, you get $€1.99$, much less than $€100$ because you didn't consider $99%$ of the same thing.



          In general adding $x%$ is multiplying by $1+frac x100$, so if you want the reverse of that you need to divide by $1+frac x100$, which is the same as multiplying by $frac11+frac x100$. Now



          $$frac11+frac x100=1-fracx100+x$$
          so the reverse of adding $x%$ is subtracting $(100cdot fracx100+x)%$




          Example: $x=10$; the reverse operation of $+10%$ is $-(100cdot frac10100+10)%simeq -9.09%$






          share|cite|improve this answer





















          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:46










          • sorry I meant £1.8174 not £1.18174
            – AdamF
            Jul 26 at 11:04










          • If you subtract the same percentage you don't get back to the initial amount. To get back to the initial amount after an increase by $x%$, you need a decrease by $frac100x100+x%$.
            – Arnaud Mortier
            Jul 26 at 16:28










          Your Answer




          StackExchange.ifUsing("editor", function ()
          return StackExchange.using("mathjaxEditing", function ()
          StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
          StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
          );
          );
          , "mathjax-editing");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "69"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: false,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          noCode: true, onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );








           

          draft saved


          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f2863240%2fadding-a-percentage-to-a-number-and-then-subtracting-the-same-percentage-to-get%23new-answer', 'question_page');

          );

          Post as a guest






























          2 Answers
          2






          active

          oldest

          votes








          2 Answers
          2






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          up vote
          0
          down vote



          accepted










          You will need to modify the percentages. If you add $x%$ to a price $P$ then your new price is $Q=P+fracPx100$. You now want to subtract $fracPx100$ from $Q$, but that is $x%$ of $P$, not $x%$ of $Q$. As a proportion of $Q$, it is $$fracfracx1001+fracx100=fracx100+x,$$
          so this means that instead of subtracting $x%$ you need to subtract $y%$ of $Q$, where $$y=frac100x100+x.$$
          For example, if you added $10%$ you must subtract $frac1000110%=9.overline09%$.






          share|cite|improve this answer





















          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:43











          • No problem :) You need to subtract $frac1650116.5%$, which is about $14.164%$.
            – Especially Lime
            Jul 26 at 10:52










          • eeeek. So £1.56 * 1.165 = £1.8174p, which is 16.5% increase of £1.56. Then to deduct 16.5% from £1.8174 I need to subtract 14.164% from £1.8174? Doesn't that leave me with £1.5919203p ? I'm so confused haha
            – AdamF
            Jul 26 at 11:12














          up vote
          0
          down vote



          accepted










          You will need to modify the percentages. If you add $x%$ to a price $P$ then your new price is $Q=P+fracPx100$. You now want to subtract $fracPx100$ from $Q$, but that is $x%$ of $P$, not $x%$ of $Q$. As a proportion of $Q$, it is $$fracfracx1001+fracx100=fracx100+x,$$
          so this means that instead of subtracting $x%$ you need to subtract $y%$ of $Q$, where $$y=frac100x100+x.$$
          For example, if you added $10%$ you must subtract $frac1000110%=9.overline09%$.






          share|cite|improve this answer





















          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:43











          • No problem :) You need to subtract $frac1650116.5%$, which is about $14.164%$.
            – Especially Lime
            Jul 26 at 10:52










          • eeeek. So £1.56 * 1.165 = £1.8174p, which is 16.5% increase of £1.56. Then to deduct 16.5% from £1.8174 I need to subtract 14.164% from £1.8174? Doesn't that leave me with £1.5919203p ? I'm so confused haha
            – AdamF
            Jul 26 at 11:12












          up vote
          0
          down vote



          accepted







          up vote
          0
          down vote



          accepted






          You will need to modify the percentages. If you add $x%$ to a price $P$ then your new price is $Q=P+fracPx100$. You now want to subtract $fracPx100$ from $Q$, but that is $x%$ of $P$, not $x%$ of $Q$. As a proportion of $Q$, it is $$fracfracx1001+fracx100=fracx100+x,$$
          so this means that instead of subtracting $x%$ you need to subtract $y%$ of $Q$, where $$y=frac100x100+x.$$
          For example, if you added $10%$ you must subtract $frac1000110%=9.overline09%$.






          share|cite|improve this answer













          You will need to modify the percentages. If you add $x%$ to a price $P$ then your new price is $Q=P+fracPx100$. You now want to subtract $fracPx100$ from $Q$, but that is $x%$ of $P$, not $x%$ of $Q$. As a proportion of $Q$, it is $$fracfracx1001+fracx100=fracx100+x,$$
          so this means that instead of subtracting $x%$ you need to subtract $y%$ of $Q$, where $$y=frac100x100+x.$$
          For example, if you added $10%$ you must subtract $frac1000110%=9.overline09%$.







          share|cite|improve this answer













          share|cite|improve this answer



          share|cite|improve this answer











          answered Jul 26 at 9:33









          Especially Lime

          19.1k22252




          19.1k22252











          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:43











          • No problem :) You need to subtract $frac1650116.5%$, which is about $14.164%$.
            – Especially Lime
            Jul 26 at 10:52










          • eeeek. So £1.56 * 1.165 = £1.8174p, which is 16.5% increase of £1.56. Then to deduct 16.5% from £1.8174 I need to subtract 14.164% from £1.8174? Doesn't that leave me with £1.5919203p ? I'm so confused haha
            – AdamF
            Jul 26 at 11:12
















          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:43











          • No problem :) You need to subtract $frac1650116.5%$, which is about $14.164%$.
            – Especially Lime
            Jul 26 at 10:52










          • eeeek. So £1.56 * 1.165 = £1.8174p, which is 16.5% increase of £1.56. Then to deduct 16.5% from £1.8174 I need to subtract 14.164% from £1.8174? Doesn't that leave me with £1.5919203p ? I'm so confused haha
            – AdamF
            Jul 26 at 11:12















          Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
          – AdamF
          Jul 26 at 10:43





          Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
          – AdamF
          Jul 26 at 10:43













          No problem :) You need to subtract $frac1650116.5%$, which is about $14.164%$.
          – Especially Lime
          Jul 26 at 10:52




          No problem :) You need to subtract $frac1650116.5%$, which is about $14.164%$.
          – Especially Lime
          Jul 26 at 10:52












          eeeek. So £1.56 * 1.165 = £1.8174p, which is 16.5% increase of £1.56. Then to deduct 16.5% from £1.8174 I need to subtract 14.164% from £1.8174? Doesn't that leave me with £1.5919203p ? I'm so confused haha
          – AdamF
          Jul 26 at 11:12




          eeeek. So £1.56 * 1.165 = £1.8174p, which is 16.5% increase of £1.56. Then to deduct 16.5% from £1.8174 I need to subtract 14.164% from £1.8174? Doesn't that leave me with £1.5919203p ? I'm so confused haha
          – AdamF
          Jul 26 at 11:12










          up vote
          0
          down vote













          If you take $99%$ off $€100$, you get $€1$. Then if you add $99%$ to $€1$, you get $€1.99$, much less than $€100$ because you didn't consider $99%$ of the same thing.



          In general adding $x%$ is multiplying by $1+frac x100$, so if you want the reverse of that you need to divide by $1+frac x100$, which is the same as multiplying by $frac11+frac x100$. Now



          $$frac11+frac x100=1-fracx100+x$$
          so the reverse of adding $x%$ is subtracting $(100cdot fracx100+x)%$




          Example: $x=10$; the reverse operation of $+10%$ is $-(100cdot frac10100+10)%simeq -9.09%$






          share|cite|improve this answer





















          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:46










          • sorry I meant £1.8174 not £1.18174
            – AdamF
            Jul 26 at 11:04










          • If you subtract the same percentage you don't get back to the initial amount. To get back to the initial amount after an increase by $x%$, you need a decrease by $frac100x100+x%$.
            – Arnaud Mortier
            Jul 26 at 16:28














          up vote
          0
          down vote













          If you take $99%$ off $€100$, you get $€1$. Then if you add $99%$ to $€1$, you get $€1.99$, much less than $€100$ because you didn't consider $99%$ of the same thing.



          In general adding $x%$ is multiplying by $1+frac x100$, so if you want the reverse of that you need to divide by $1+frac x100$, which is the same as multiplying by $frac11+frac x100$. Now



          $$frac11+frac x100=1-fracx100+x$$
          so the reverse of adding $x%$ is subtracting $(100cdot fracx100+x)%$




          Example: $x=10$; the reverse operation of $+10%$ is $-(100cdot frac10100+10)%simeq -9.09%$






          share|cite|improve this answer





















          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:46










          • sorry I meant £1.8174 not £1.18174
            – AdamF
            Jul 26 at 11:04










          • If you subtract the same percentage you don't get back to the initial amount. To get back to the initial amount after an increase by $x%$, you need a decrease by $frac100x100+x%$.
            – Arnaud Mortier
            Jul 26 at 16:28












          up vote
          0
          down vote










          up vote
          0
          down vote









          If you take $99%$ off $€100$, you get $€1$. Then if you add $99%$ to $€1$, you get $€1.99$, much less than $€100$ because you didn't consider $99%$ of the same thing.



          In general adding $x%$ is multiplying by $1+frac x100$, so if you want the reverse of that you need to divide by $1+frac x100$, which is the same as multiplying by $frac11+frac x100$. Now



          $$frac11+frac x100=1-fracx100+x$$
          so the reverse of adding $x%$ is subtracting $(100cdot fracx100+x)%$




          Example: $x=10$; the reverse operation of $+10%$ is $-(100cdot frac10100+10)%simeq -9.09%$






          share|cite|improve this answer













          If you take $99%$ off $€100$, you get $€1$. Then if you add $99%$ to $€1$, you get $€1.99$, much less than $€100$ because you didn't consider $99%$ of the same thing.



          In general adding $x%$ is multiplying by $1+frac x100$, so if you want the reverse of that you need to divide by $1+frac x100$, which is the same as multiplying by $frac11+frac x100$. Now



          $$frac11+frac x100=1-fracx100+x$$
          so the reverse of adding $x%$ is subtracting $(100cdot fracx100+x)%$




          Example: $x=10$; the reverse operation of $+10%$ is $-(100cdot frac10100+10)%simeq -9.09%$







          share|cite|improve this answer













          share|cite|improve this answer



          share|cite|improve this answer











          answered Jul 26 at 9:32









          Arnaud Mortier

          18.6k22159




          18.6k22159











          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:46










          • sorry I meant £1.8174 not £1.18174
            – AdamF
            Jul 26 at 11:04










          • If you subtract the same percentage you don't get back to the initial amount. To get back to the initial amount after an increase by $x%$, you need a decrease by $frac100x100+x%$.
            – Arnaud Mortier
            Jul 26 at 16:28
















          • Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
            – AdamF
            Jul 26 at 10:46










          • sorry I meant £1.8174 not £1.18174
            – AdamF
            Jul 26 at 11:04










          • If you subtract the same percentage you don't get back to the initial amount. To get back to the initial amount after an increase by $x%$, you need a decrease by $frac100x100+x%$.
            – Arnaud Mortier
            Jul 26 at 16:28















          Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
          – AdamF
          Jul 26 at 10:46




          Thank you so much for your time commenting on my post! I'm still a bit confused, maths isn't my strong point I'm afraid. How would this work If I used as selling price of £1.56, added on 16.5% and then wanted to subtract 16.5% from £1.18174 to get back to £1.56? How would that work in that formula you supplied? Thanks in advance!
          – AdamF
          Jul 26 at 10:46












          sorry I meant £1.8174 not £1.18174
          – AdamF
          Jul 26 at 11:04




          sorry I meant £1.8174 not £1.18174
          – AdamF
          Jul 26 at 11:04












          If you subtract the same percentage you don't get back to the initial amount. To get back to the initial amount after an increase by $x%$, you need a decrease by $frac100x100+x%$.
          – Arnaud Mortier
          Jul 26 at 16:28




          If you subtract the same percentage you don't get back to the initial amount. To get back to the initial amount after an increase by $x%$, you need a decrease by $frac100x100+x%$.
          – Arnaud Mortier
          Jul 26 at 16:28












           

          draft saved


          draft discarded


























           


          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f2863240%2fadding-a-percentage-to-a-number-and-then-subtracting-the-same-percentage-to-get%23new-answer', 'question_page');

          );

          Post as a guest













































































          Comments

          Popular posts from this blog

          What is the equation of a 3D cone with generalised tilt?

          Color the edges and diagonals of a regular polygon

          Relationship between determinant of matrix and determinant of adjoint?