Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Percentage Formula in Excel

How to Percentage Formula in Excel

AsmiBy AsmiJanuary 2, 2023
percentage formula in excel

You can perform a variety of numeric manipulations, including calculating a percentage value in MS Excel. Whether you’re calculating profit-loss, probability, or the total score of a student, you can use MS Excel to calculate the percentage quickly. You can simply enter the percentage formula in one cell and use Flash Fill to fill the remaining cells.

The formula to calculate percentages in MS Excel is =(obtained number/ total number)*100. For example, we have an Excel document of the percentage calculation of 12 students.

Calculate Percentage Excel

We first calculated the total number obtained by each student out of the total achievable number, 300. Then we used the percentage formula to calculate the percentage received by Hugo.

=E2/F2*100

flash fill

To apply the same formula in all the remaining cells, we placed our cursor on the bottom-right corner of the G2 cell and dragged it to G13. Excel uses AI to sense a pattern in the formula and automate a result. This method is termed Flash Fill.

There are several other percentage formulas to calculate different results in Excel.

Table of Contents

  • Calculate the Difference in Values as a Percentage
  • Calculate Amount Using Percentage and Total Value
  • Calculate Total Value Using Percentage and Amount
  • Increase or Decrease Amount Using Percentage

Calculate the Difference in Values as a Percentage

Say you’re calculating the profit percentages for the year 2022 and want to see the difference between the profit percentage obtained in December from the profit obtained in January. You can use the format =(value1- value2)/total profit*100

Calculate percentage by value differences

In this example, the profit percentage seems identical for the month of January and December. To calculate the difference between January and December, we used the following formula:

=((B2-B12)/C2)*100

The profit percentage for the month of December is greater than January by 0.382%

Calculate Amount Using Percentage and Total Value

If you received a discount of 20% when shopping for a handbag worth $15, you could be curious about the total discounted amount from the total price. You can calculate the discount amount using a formula in =Total price*discount percentage format.

Calculate Amount Excel

Here, we’ve entered the total price of the handbag and the discounted price in the following formula to calculate the discounted amount:

=A2*B2

The total discount received is $3.

Calculate Total Value Using Percentage and Amount

Similar to calculating the amount, you can calculate the total value using the amount and percentage. For instance, you spent $20 buying x worth of potatoes after a 2% discount. You can use the formula in =amount/percentage to calculate the total value.

Calculate Total Cost

We entered these values in an Excel worksheet and calculated the total amount you would have to pay before the discount

=B31/A31

The potatoes were originally worth $1000.

Increase or Decrease Amount Using Percentage

If you want to generate a new amount by increasing a percentage, you need to enter a different formula. Say you want to give each of your employees a 15% hike in their salaries as a bonus. You need to enter the percentage formula in =existing salary * (1+percentage) format.

Increase amount by percent Excel

In this spreadsheet, we’ve entered the salary of employees in column B. In the next column, we’ve used the formula and used flash fill to fill in the remaining cells.

=B2*(1+15%)

Similarly, if you want to decrease a certain percentage from the total amount, you will need to use the formula in =existing amount *(1-percentage) format to generate your new amount.

Decrease amount by percent Excel

We’ve used the same values as above but decreased the salaries by 15%

=B2*(1-15%)

how-to
Asmi

Hello! I'm Asmi, and I've been writing professionally since 2020. I'm here to help you learn your way around Microsoft Office-based programs. Besides Office, I also write on technical fixes and general how-to(s). Apart from writing, I like giving back to the community by volunteering.

Related Posts

how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
how to change background on teams

How to Change Background on Teams

January 9, 2023
how to test call on teams

How to Test Call on Teams

January 7, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
how to set print area in excel

How to Set Print Area in Excel

January 5, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
what is ghost of tsushima legends

What is the Ghost of Tsushima Legends Mode

January 12, 2023
raid 5 vs raid 10

RAID 5 Vs RAID 10 – Which One Is Better?

January 12, 2023
best-tv-settings-for-gaming

Best TV Settings for Gaming

January 9, 2023
You may also like
tv-screen-goes-black-randomly

TV Screen Goes Black Randomly? Try These 11 Fixes

January 15, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how-to-open-and-use-chrome-settings

How to Open and Use Chrome Settings

January 16, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Editorial Guidelines
  • Fact-Checking Policy
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday.

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