• 470K Members
• 5,688 Online
• 568K Conversations

New Contributor

# 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

4 Replies

# Re: Adding x% to a total

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

# Re: Adding x% to a total

Hi there

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

Cheers

Damien

# Re: Adding x% to a total

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

# Re: Adding x% to a total

Hi pal

Happy that you have some options to go with!

Best wishes and have a great weekend ahead

Damien

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies