Forum Discussion

_jwalker's avatar
_jwalker
Copper Contributor
Apr 11, 2019

Adding x% to a total

I'm attempting to add a certain percentage to a total product, for instance:

cell 1A is the multiplier to a sum in cell 1B; "2 x 10"

cell 1C is the product of 1A x 1B; "2 x 10 = 20"

I would like cell 1D to show the product in 1C + ?%; "20 + 20% = 24".

I tried the simple way first "1C+20%" as the formula string in 1D, but all that did was add 20+ + 20 = 40... LOL.

I then did a search of formulas but came up with nothing that looked like it would do the job.

I would have thought it would be a fairly simple one to figure out... I must be missing something.

Anyone out there have any ideas?

Thanks :j

excel

4 Replies

    • _jwalker's avatar
      _jwalker
      Copper Contributor
      Apr 12, 2019

      Damien_Rosario 

      Twifoo 

       

      Thank you both for the prompt replies!

      Both of your formulas worked perfectly and though there is a bit more involved with entering Damien's formula, it seems like it would be more practical as the percentage would not have to be converted to a decimal (with it's associated issues).

      I will be using both formulas for a while to see how they work out.

       

      Thank you both very much!

       

      Regards, :j

      • Damien_Rosario's avatar
        Damien_Rosario
        Silver Contributor
        Apr 12, 2019

        _jwalker 

         

        Hi pal

         

        Happy that you have some options to go with!

         

        Best wishes and have a great weekend ahead

         

        Damien

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 11, 2019
    To add 20% to the total in C1, the formula in D1 can be:
    =C1*1.2

Resources