Skip to main content

How to calculate percentages in Excel

Turning data into percentages can give you a new insight, or make summarising heaps of data that bit easier. Calculating percentages is easy with a calculator, but it's even easier if you have a tool to automatically calculate percentages for you. This is where the percentage formula in Excel can give you the answer you need in seconds.

Here’s how to calculate percentages in Excel.

Difficulty

Easy

Duration

5 minutes

What You Need

  • PC

  • Microsoft Excel

What is the formula to calculate percentage?

There are various formulas you can use to calculate a percentage. Here are two of the most common methods.

Step 1: In this specific example, I’ll be calculating the difference between the profit and revenue. Click the cell you want the percentage to appear within. Now type in =(B2-C2)/B2. The / represents the division function.

Entering a formula to calculate a percentage in Excel.
Image used with permission by copyright holder

Step 2: Press the Enter key on your keyboard in order to confirm the formula.

Step 3: In the toolbar, click the percentage icon. In my example, there’s a 65% difference between the profit and revenue. If I change the profit amount to a higher figure, that percentage will decline.

The percentage icon is highlighted in Excel.
Image used with permission by copyright holder

Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells. For example, to pass a driving theory test, I need to get 80% of the questions correct. To find out the percentage for this specific question, I’ve entered =B2/C2.

Entering a custom formula that calculates percentages in Excel.
Image used with permission by copyright holder

What is the easiest way to find percentages?

Now that we’ve explained how to calculate percentages, let’s take a look at the easiest way to find percentages via the drag feature.

Step 1: Click the cell where you’ve entered the formula to calculate a percentage.

Step 2: On the bottom-right corner of that cell, drag it down to where your column ends, or wherever you want percentages to be shown.

In my example, I’ve dragged it down to reveal the difference between the percentage of profit being generated compared to the revenue for each month that’s listed within my spreadsheet.

Using the drag feature in Excel to replicate the percentage formula in other cells.
Image used with permission by copyright holder

How do I find 10% of a number in Excel?

Finding a specific percentage of a number within your spreadsheet can be achieved via a straightforward formula.

Step 1: Click the cell you want to find the percentage of a number in.

Step 2: Now enter, for example, =10%50. The asterisk in this formula represents the multiplication function. Press *Enter on your keyboard to confirm the result.

Entering the formula to find a specific percentage of a number in Excel.
Image used with permission by copyright holder

Step 3: I’ve applied this same formula on my main Excel profit versus revenue spreadsheet as well. Just replace the number 50 with the cell number where the figure is located.

Entering the formula to find a specific percentage of a cell’s value in Excel.
Image used with permission by copyright holder

For more on Excel's other functions, check out our guides on how to use concatenate, and how to use IF in Excel. You can also see what's new in Microsoft Office.

Editors' Recommendations

Zak Islam
Computing Writer
Zak Islam was a freelance writer at Digital Trends covering the latest news in the technology world, particularly the…
How to change your Google background in Chrome
A man holding a teacup staring at laptop screen.

Google Chrome is fairly plain, but it doesn't need to be. One way to spice it up is by changing the overall look with a new theme. Not only can you change the New Tab background but you can also change the overall colors of your tabs, bookmarks bar, and more.

Read more
How to screen record on an iPhone or iPad
iPhone X tips and tricks

Sometimes taking a screenshot isn't enough to get your point across when you're trying to share something from your shine new iPhone 15 Pro. While you can take multiple screenshots to help a friend or family member learn how to do something or even just show off your finesse in Genshin Impact, why not just give them a video clip where they can follow the entire process?

The good news is that Apple makes this really easy to do in iOS 17 without the need for any third-party apps. Just like taking a screenshot, screen recordings are automatically saved to your photo library, where you can trim them, edit them, and share them like any other video clip.

Read more
How to insert a checkbox in Word
A man working in private industrious workspace with laptop.

If you have a to-do list you'd like to put together, you should know that you can use Microsoft Word to create one. In fact, you can even create lists in Word with checkboxes that can be checked electronically. And adding checkboxes to a Word document isn't as difficult as you might think. In this guide, we'll show you step by step how to insert a checkbox in Word. We'll first show you how to enable the checkbox feature and then how to insert one.

Read more