قالب وردپرس درنا توس
Home / Tips and Tricks / Add percentages with Excel

Add percentages with Excel



Excel Logo on a gray background

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.

click on empty cell

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.

sum formula

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.

select both numbers

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.

check mark formula

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.

add two numbers

Click the blank cell next to your percentage to tell Excel where we will display the result of our formula.

click on empty cell

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:

=A3+(A3*B3)

Formula bar

Press “Enter” on the keyboard or click the check mark to the left of the formula bar to display the result.

check mark

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.




Source link