How to Run Your Own DNS Server on Your Local Network, How to Check If the Docker Daemon or a Container Is Running, How to View Kubernetes Pod Logs With Kubectl, How to Pass Environment Variables to Docker Containers, How to Use Docker to Containerize PHP and Apache, How to Use State in Functional React Components, How to Create a Simple Bot In Microsoft Teams, How to Get Started With Portainer, a Web UI for Docker, How to Restart Kubernetes Pods With Kubectl, How to Find Your Apache Configuration Folder, How to Send a Message to Slack From a Bash Script, How to Get the Size of an Amazon S3 Bucket, When Not to Use Docker: Cases Where Containers Dont Help, AVerMedia PW515 4K Ultra HD Webcam Review, Gozney Roccbox Pizza Oven Review: Restaurant-Quality in a Portable Package, Harber London Leather Desk Mat Review: More Than Just Stylish, VIZIO M-Series Soundbar and Subwoofer Review: The Best Option Under $200, Kovol 140W PD 2-Port GaN Wall Charger Review: This Brick Gets The Job Done, How to Calculate Percentage in Google Sheets, SwitchBot Lock Review: A Hi-Tech Way to Unlock Your Door, GRID Studio Framed Art Review: A Tech Trip Down Memory Lane, Every Game Microsoft Ever Included in Windows, Ranked, 2022 LifeSavvy Media. What is SSH Agent Forwarding and How Do You Use It? Insert your two figures in columns A and B. Before working as a freelancer, Bryan was the Managing Editor for The Next Web. 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. 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). How-To Geek is where you turn when you want experts to explain technology. You can add the following formula to an empty cell, or the formula bar: Press Enter on the keyboard or click the checkmark to the left of the formula bar to display the result. In this example, were going to click and highlight cell C3. For the last 10 years, he's covered the technology beat, including gadgets, social media, security, and web culture. How to Manage an SSH Config File in Windows and Linux, How to Run GUI Applications in a Docker Container, How to Use Cron With Your Docker Containers, How to Check If Your Server Is Vulnerable to the log4j Java Exploit (Log4Shell). Choose a cell to display the sum of your two percentages. 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. If you actually want to add a percentage to a numberadding 15% to 200, for examplethen this example is what youre looking for. All Rights Reserved. Before working as a freelancer, Bryan was the Managing Editor for The Next Web. Once you understand the basic concepts of Excel, youll master simple calculations like this in no time. What's the Difference Between GPT and MBR, Take Screenshot by Tapping Back of iPhone, Pair Two Sets of AirPods With the Same iPhone, Download Files Using Safari on Your iPhone, Turn Your Computer Into a DLNA Media Server, Download and Install Older Versions of macOS. Well take a look at both. A, in our example, will be the whole number, while B will be our percentage. Can I Use iCloud Drive for Time Machine Backups? Thats itits all pretty basic Excel math. Read more Do you want to add percentages in Excel? What Is a PEM File and How Do You Use It? 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. For the last 10 years, he's covered the technology beat, including gadgets, social media, security, and web culture. When you purchase through our links we may earn a commission. Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles. Since we launched in 2006, our articles have been read more than 1 billion times. Click the empty cell next to your percentage to tell Excel where well be displaying the result of our formula. By submitting your email, you agree to the Terms of Use and Privacy Policy. Bryan has worked in journalism and publishing for more than 15 years. Can Power Companies Remotely Adjust Your Smart Thermostat? Click in cell A3 and then command click cell B3 to select both. You can add percentages like any other number. If you have more cells, you can click the first and then Shift + Click the last to select all cells in a range. Highlight a Row Using Conditional Formatting, How to Add a Word or Phrase to Android's Auto, Hide or Password Protect a Folder in Windows, Access Your Router If You Forget the Password, Access Your Linux Partitions From Windows, How to Connect to Localhost Within a Docker Container. There are a few ways to do this. Bryan has worked in journalism and publishing for more than 15 years. 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. This will give us the desired result, a 15% increase, or 94.45. Control All Your Smart Home Devices in One App. 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. We select and review products independently. 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.