Apr 10 2019 09:27 PM
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
Apr 10 2019 10:53 PM
Apr 10 2019 10:59 PM - edited Apr 10 2019 11:00 PM
Hi there
If I assume right, maybe just try =(C1*20%)+C1 in D1?
Please see attached sample.
Cheers
Damien
Apr 11 2019 06:54 PM
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
Apr 11 2019 08:12 PM
Hi pal
Happy that you have some options to go with!
Best wishes and have a great weekend ahead
Damien