Do you want to add percentages in Excel? This can be done in a number of ways. In a way, you could be talking about adding percentage values. Or maybe you are looking for a way to increase a value of 15%. We will look at both.
How to add up percentages
You can add percentages like any other number. Choose a cell to display the sum of your two percentages. In this example, we are going to click and highlight cell C3.
Type “= sum” (without quotation marks) in the formula bar, then click the first result, the sum formula, which will add all the numbers in a range of cells.
Click in cell A3 and then click cell B3 to select both. If you have more cells, you can click the first one and then Shift + click the last one to select all cells in a range.
Once your chosen cells are highlighted, press “Enter” on the keyboard, or press the check mark in the formula bar to run the formula and display the sum of your percentages.
How to Apply a Percent Increase
If you actually want to add a percentage to a number – say, add 15% to 200 – then this example is what you’re looking for. It’s worth noting that you can run the formula in reverse (15% off 200) by changing the “+” sign in the formula below to a “-” sign.
Insert your two numbers in columns A and B. A, in our example, is the whole number, while B is our percentage.
Click the blank cell next to your percentage to tell Excel where we will display the result of our formula.
We’re going to apply a formula that tells Excel to take 15% of 83 (or 12.45) and add it to our original number (83). This gives us the desired result, an increase of 15%, or 94.45. You can add the following formula to a blank cell or to the formula bar:
Press “Enter” on the keyboard or click the check mark to the left of the formula bar to display the result.
That’s it – it’s all pretty simple Excel math. Once you understand the basic concepts of Excel, you’ll be able to master simple calculations like this in no time.