How to add percentages to a price
How to Add Percentages Using Excel Bryan Clark @bryanclark January 11, 2021, 10:24am EDT Do you want to add percentages in Excel? There are a few ways to do this. In on
How to Add Percentages Using Excel
- Bryan Clark
@bryanclark
- January 11, 2021, 10:24am EDT
Do you want to add percentages in Excel? There are a few ways to do this. In one sense, you could be talking about adding percentage values. Or, you could be looking for a way to add a 15% increase to a value. Well take a look at both.
How to Add Percentages Together
You can add percentages like any other number. Choose a cell to display the sum of your two percentages. In this example, were going to click and highlight cell C3.
In the formula bar, type =sum (without quotes) and then click the first result, the sum formula, which adds all numbers in a range of cells.
Advertisement
Click in cell A3 and then command click cell B3 to select both. If you have more cells, you can click the first and then Shift + Click the last to select all cells in a range.
Once your chosen cells are highlighted, hit Enter on the keyboard, or press the checkmark in the formula bar to execute the formula and display the sum of your percentages.
The Best Tech Newsletter Anywhere
Join 425,000 subscribers and get a daily digest of features, articles, news, and trivia. Sign Me Up! We've got your info - thanks for signing up! We were unable to subscribe you! Please check your e-mail address or contact us for assistance. Signing you up...
By submitting your email, you agree to the Terms of Use and Privacy Policy.
How to Apply a Percentage Increase
If you actually want to add a percentage to a numberadding 15% to 200, for examplethen this example is what youre looking for. Its worth noting that you can do the formula in reverse (taking 15% off of 200) by changing the + sign to a - sign in the formula below.
Insert your two figures in columns A and B. A, in our example, will be the whole number, while B will be our percentage.
Advertisement
Click the empty cell next to your percentage to tell Excel where well be displaying the result of our formula.
Were 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 will give us the desired result, a 15% increase, or 94.45. You can add the following formula to an empty cell, or the formula bar:=A3+(A3*B3)
Press Enter on the keyboard or click the checkmark to the left of the formula bar to display the result.
Thats itits all pretty basic Excel math. Once you understand the basic concepts of Excel, youll master simple calculations like this in no time.
Bryan Clark
Bryan has worked in journalism and publishing for more than 15 years. For the last 10 years, he's covered the technology beat, including gadgets, social media, security, and web culture. Before working as a freelancer, Bryan was the Managing Editor for The Next Web. These days he spends his time at a number of publications, both online and off, including The New York Times, Popular Science, and The Next Web, among others. Read Full Bio »