Close Menu
Best in TechnologyBest in Technology
  • News
  • Phones
  • Laptops
  • Gadgets
  • Gaming
  • AI
  • Tips
  • More
    • Web Stories
    • Global
    • Press Release

Subscribe to Updates

Get the latest tech news and updates directly to your inbox.

What's On

iOS 26 Beta 3 Update for iPhone Released With New Stock Wallpapers, Darker Liquid Glass Appearance

8 July 2025

OnePlus Nord 5, Nord CE 5 Launch Today: Know Price, Expected Features and Specifications

8 July 2025

AI+ Nova 5G, Pulse India Launch Today: Know Price, Specifications and More

8 July 2025
Facebook X (Twitter) Instagram
Just In
  • iOS 26 Beta 3 Update for iPhone Released With New Stock Wallpapers, Darker Liquid Glass Appearance
  • OnePlus Nord 5, Nord CE 5 Launch Today: Know Price, Expected Features and Specifications
  • AI+ Nova 5G, Pulse India Launch Today: Know Price, Specifications and More
  • Samsung Galaxy Z Fold 7 Tipped to Get a Noticeable Price Hike Over Galaxy Z Fold 6 in India
  • Anthem Is the Latest Video Game Casualty. What Should End-of-Life Care Look Like for Games?
  • Samsung May Upgrade AI-Powered Audio Eraser Feature in One UI 8 With Real-Time Editing Support
  • Amazon Prime Day Sale 2025: Samsung Galaxy S24 Ultra to Be Available Under Rs. 80,000
  • Realme 15 Series to Feature AI Edit Genie, a Voice-Enabled Photo Editing Tool
Facebook X (Twitter) Instagram Pinterest Vimeo
Best in TechnologyBest in Technology
  • News
  • Phones
  • Laptops
  • Gadgets
  • Gaming
  • AI
  • Tips
  • More
    • Web Stories
    • Global
    • Press Release
Subscribe
Best in TechnologyBest in Technology
Home » How to calculate percentages in Excel
News

How to calculate percentages in Excel

News RoomBy News Room18 September 20243 Mins Read
Share Facebook Twitter Pinterest LinkedIn Tumblr Reddit Telegram Email
Share
Facebook Twitter LinkedIn Pinterest Email

If you are using Microsoft Excel to manage numerical data, at some point you’re inevitably going to display percentages.

Doing so 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.

Here’s how to calculate percentages in 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.

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.

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.

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.

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.

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.

For more on Excel’s other functions, check out our guides on how to use concatenate, and how to use IF in Excel.











Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
Previous ArticleMost US Teens Use Generative AI. Most of Their Parents Don’t Know
Next Article Google Working on Bringing Cross-Platform Chat Encryption ‘As Soon as Possible’ After iOS 18 Adds RCS Support

Related Articles

News

Anthem Is the Latest Video Game Casualty. What Should End-of-Life Care Look Like for Games?

8 July 2025
News

Why Jolly Ranchers Are Banned in the UK but Not the US

7 July 2025
News

Thanks to Zillow, Your Friends Know How Much Your House Costs—or if You’re Secretly Rich

7 July 2025
News

People Are Using AI Chatbots to Guide Their Psychedelic Trips

7 July 2025
News

On Mexico’s Caribbean Coast, There’s Lobster for the Tourists and Microplastics for Everyone Else

7 July 2025
News

How to Use Voice Typing on Your Phone

6 July 2025
Demo
Top Articles

ChatGPT o1 vs. o1-mini vs. 4o: Which should you use?

15 December 2024101 Views

Costco partners with Electric Era to bring back EV charging in the U.S.

28 October 202495 Views

Oppo Reno 14, Reno 14 Pro India Launch Timeline and Colourways Leaked

27 May 202582 Views

Subscribe to Updates

Get the latest tech news and updates directly to your inbox.

Latest News
Phones

Samsung May Upgrade AI-Powered Audio Eraser Feature in One UI 8 With Real-Time Editing Support

News Room8 July 2025
Phones

Amazon Prime Day Sale 2025: Samsung Galaxy S24 Ultra to Be Available Under Rs. 80,000

News Room8 July 2025
Phones

Realme 15 Series to Feature AI Edit Genie, a Voice-Enabled Photo Editing Tool

News Room7 July 2025
Most Popular

The Spectacular Burnout of a Solar Panel Salesman

13 January 2025124 Views

ChatGPT o1 vs. o1-mini vs. 4o: Which should you use?

15 December 2024101 Views

Costco partners with Electric Era to bring back EV charging in the U.S.

28 October 202495 Views
Our Picks

Samsung Galaxy Z Fold 7 Tipped to Get a Noticeable Price Hike Over Galaxy Z Fold 6 in India

8 July 2025

Anthem Is the Latest Video Game Casualty. What Should End-of-Life Care Look Like for Games?

8 July 2025

Samsung May Upgrade AI-Powered Audio Eraser Feature in One UI 8 With Real-Time Editing Support

8 July 2025

Subscribe to Updates

Get the latest tech news and updates directly to your inbox.

Facebook X (Twitter) Instagram Pinterest
  • Privacy Policy
  • Terms of use
  • Advertise
  • Contact Us
© 2025 Best in Technology. All Rights Reserved.

Type above and press Enter to search. Press Esc to cancel.