Skip to main content

How to calculate percentages in Excel

how to alphabetize in excel microsoft
PixieMe/Shutterstock

Turning data into percentages can give you a new insight, or make summarizing heaps of data a bit easier. This is where the percentage formula in Excel can give you the answer you need in seconds. And don't worry, calculating percentages in Excel doesn't require complicated steps. Let us show you how to get it done.

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. Select 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, select 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: Select 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: Select 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.

Zak Islam
Former Digital Trends Contributor
Zak Islam was a freelance writer at Digital Trends covering the latest news in the technology world, particularly the…
How to change your password in ChatGPT
ChatGPT giving a response about its knowledge cutoff.

You can't be too careful on today's internet, and routinely updating the passwords for your most visited sites is a great way to keep your personal information safe online. That's especially true when using generative AI programs like ChatGPT, whether you've been sharing your account with a friend or simply want some extra peace of mind.

Read more
There are two versions of Windows 11. Here’s how to decide between them
Windows 11 logo on a laptop.

If you’re ready to take the plunge and purchase an upgraded version of Windows, then the biggest question you have is “which one?” Both Windows 11 Pro and Windows 11 Home are powerful operating systems with robust feature sets at affordable prices.

To help you make an informed decision, we’ll walk you through a feature comparison along with the differences in security, power, and price.
Windows 11 Pro or Windows 11 Home?
Microsoft tries to introduce the intent behind the Windows 11 versions in the naming of the systems.

Read more
Best color laser printers for 2024: tested and reviewed
The Color LaserJet Pro 4301fdw has good photo print quality on glossy paper.

The best color laser printers are a great investment, saving you quite a bit of time and money. Given the high cost of replacing cartridges in inkjet printers, you'll find color laser printers surprisingly affordable. Laser printers use toner, which lasts a long time, delivering a low cost per page for monochrome documents and fast color prints. The best color laser printers offer quick performance and reliability to help keep your home office or small business productive.

If you need to scan documents for record-keeping and photo capture or want the convenience of a color copier, an all-in-one color laser printer is an essential tool for your small business or personal use. For a small added cost, you get expanded capabilities. That's why every model on this list is an all-in-one from the best printer brands.

Read more