Forum Discussion

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 c...

excel

_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