![Mastering Excel: A Step-by-Step Guide on Adding and Calculating Percentages](https://thmb.techidaily.com/ebbfd91fc57bf5ea9818d4e87d8cfd35544a71921ce7ca73b2986ee75e83dd45.jpg)
Mastering Excel: A Step-by-Step Guide on Adding and Calculating Percentages
![](/images/site-logo.png)
Mastering Excel: A Step-by-Step Guide on Adding and Calculating Percentages
Quick Links
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. We’ll 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, we’re 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.
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.
How to Apply a Percentage Increase
If you actually want to add a percentage to a number—adding 15% to 200, for example—then this example is what you’re looking for. It’s 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.
Click the empty cell next to your percentage to tell Excel where we’ll be displaying 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 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.
That’s it—it’s all pretty basic Excel math. Once you understand the basic concepts of Excel, you’ll master simple calculations like this in no time.
Also read:
- [Updated] Aviary Creator Searching for Affordable Filters
- [Updated] From Silence to Symphony Enhancing Stories with IG Music
- [Updated] In 2024, Constructing YouTube Playlists Made Simple
- 動画編集: 3つの効果的な方法で短くトリミングするコツ
- 無料 MP3 & M4A変換ソフトウェア一覧 - 高速・簡単な音楽ファイル変換
- Easy Steps to Download Your Epson ET-2750 Printer Driver for Microsoft Windows Systems
- How to Securely Save YouTube Videos to Your Android Smartphone for Free
- In 2024, The Digital Sound Artist's Guide Discovering No-Cost Audio Effect Solutions
- In 2024, Top IMEI Unlokers for iPhone 14 Pro Max and Android Phones
- Master the Art of DVD Upgrading: Comprehensive Tutorial for Turning DVDs Into Crystal Clear 480P 60FPS Videos
- Master the Art of Mobile Video Transfers - A Comprehensive Walkthrough for Android Users
- Mastering YouTube: A Step-by-Step Guide to Turning On/Off Restricted Mode
- MP3ファイルをWAV形式にアップコンバートする手軽かつ効果的な方法:Windows、Mac両用のフリーソフトウェア・無料サイト推薦
- New The Glitch Effect Shows Errors and Flaws in the Image or a Video. The Write-Up Presents the Complete Procedure of Adding Premiere Pros Glitch Effect and Introduces Eight Free Glitch Effects for 2024
- The Magnificent Art of Pokemon Go Streaming On Vivo Y02T? | Dr.fone
- Title: Mastering Excel: A Step-by-Step Guide on Adding and Calculating Percentages
- Author: David
- Created at : 2024-12-30 20:10:17
- Updated at : 2025-01-06 19:04:39
- Link: https://win11.techidaily.com/mastering-excel-a-step-by-step-guide-on-adding-and-calculating-percentages/
- License: This work is licensed under CC BY-NC-SA 4.0.