Home

Adding x% to a total

%3CLINGO-SUB%20id%3D%22lingo-sub-433990%22%20slang%3D%22en-US%22%3EAdding%20x%25%20to%20a%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433990%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20attempting%20to%20add%20a%20certain%20percentage%20to%20a%20total%20product%2C%20for%20instance%3A%3C%2FP%3E%3CP%3Ecell%201A%20is%20the%20multiplier%20to%20a%20sum%20in%20cell%201B%3B%20%222%20x%2010%22%3C%2FP%3E%3CP%3Ecell%201C%20is%20the%20product%20of%201A%20x%201B%3B%20%222%20x%2010%20%3D%2020%22%3C%2FP%3E%3CP%3EI%20would%20like%20cell%201D%20to%20show%20the%20product%20in%201C%20%2B%20%3F%25%3B%20%2220%20%2B%2020%25%20%3D%2024%22.%3C%2FP%3E%3CP%3EI%20tried%20the%20simple%20way%20first%20%221C%2B20%25%22%20as%20the%20formula%20string%20in%201D%2C%20but%20all%20that%20did%20was%20add%2020%2B%20%2B%2020%20%3D%2040...%20LOL.%3C%2FP%3E%3CP%3EI%20then%20did%20a%20search%20of%20formulas%20but%20came%20up%20with%20nothing%20that%20looked%20like%20it%20would%20do%20the%20job.%3C%2FP%3E%3CP%3EI%20would%20have%20thought%20it%20would%20be%20a%20fairly%20simple%20one%20to%20figure%20out...%20I%20must%20be%20missing%20something.%3C%2FP%3E%3CP%3EAnyone%20out%20there%20have%20any%20ideas%3F%3C%2FP%3E%3CP%3EThanks%20%3Aj%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-433990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-434196%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20x%25%20to%20a%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-434196%22%20slang%3D%22en-US%22%3ETo%20add%2020%25%20to%20the%20total%20in%20C1%2C%20the%20formula%20in%20D1%20can%20be%3A%3CBR%20%2F%3E%3DC1*1.2%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-434226%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20x%25%20to%20a%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-434226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F318739%22%20target%3D%22_blank%22%3E%40_jwalker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20there%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20assume%20right%2C%20maybe%20just%20try%26nbsp%3B%3CSTRONG%3E%3CFONT%3E%3D(C1*20%25)%2BC1%3C%2FFONT%3E%3C%2FSTRONG%3E%20in%20D1%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20sample.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-442080%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20x%25%20to%20a%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-442080%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20both%20for%20the%20prompt%20replies!%3C%2FP%3E%3CP%3EBoth%20of%20your%20formulas%20worked%20perfectly%20and%20though%20there%20is%20a%20bit%20more%20involved%20with%20entering%20Damien's%20formula%2C%20it%20seems%20like%20it%20would%20be%20more%20practical%20as%20the%20percentage%20would%20not%20have%20to%20be%20converted%20to%20a%20decimal%20(with%20it's%20associated%20issues).%3C%2FP%3E%3CP%3EI%20will%20be%20using%20both%20formulas%20for%20a%20while%20to%20see%20how%20they%20work%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20both%20very%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20%3Aj%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-442271%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20x%25%20to%20a%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-442271%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F318739%22%20target%3D%22_blank%22%3E%40_jwalker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20pal%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHappy%20that%20you%20have%20some%20options%20to%20go%20with!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%20and%20have%20a%20great%20weekend%20ahead%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
_jwalker
New Contributor

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
To add 20% to the total in C1, the formula in D1 can be:
=C1*1.2

@_jwalker 

 

Hi there

 

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

 

Please see attached sample.

 

Cheers

Damien

@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

@_jwalker 

 

Hi pal

 

Happy that you have some options to go with!

 

Best wishes and have a great weekend ahead

 

Damien

Related Conversations