Adding x% to a total

[_jwalker]

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

[#2]

To add 20% to the total in C1, the formula in D1 can be:
=C1*1.2

[#3]

@_jwalker 

Hi there

If I assume right, maybe just try =(C1*20%)+C1 in D1?

Please see attached sample.

Cheers

Damien

[#4]

@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

[#5]

@_jwalker 

Hi pal

Happy that you have some options to go with!

Best wishes and have a great weekend ahead

Damien