The fastest and easiest way to calculate percentages (%)

The method of calculating percentages may sound simple but actually quite complicated, to get the most accurate results we need to rely on many different factors. With different data we will calculate different percentages, in addition to conventional percentage methods we can also use Excel spreadsheets to calculate faster.

Usually based on a specific number we will compare the percentage of growth, the percentage of capital, the percentage of interest, the increase and decrease, etc. Generally for people who do not work with numbers very often, the percentage calculation is very complicated, but if you understand the nature of the calculation, it becomes quite simple. Below is a detailed breakdown of how to calculate percentages in different forms.

How to calculate the percentage of growth

Calculate the percentage of growth used to compare the growth rates between months, quarters or years of the same specific unit. For example, compare the percentage growth of a company from previous year to next year, last month to next month, etc. Especially, this percentage may be negative in case the business result of the previous year is inferior to the following year.

Example problem:

Calculating the growth percentage of an enterprise A. Knowing that the business results of enterprise A in 2018 is VND 200 billion, in 2017 it is VND 150 billion.

The percentage growth in 2018 is calculated as follows:

  • (2018 revenue - 2017 revenue) / 2017 revenue * 100 = (200 - 150) / 150 * 100 = 33.33%

Thus we conclude that the growth rate of 2018 compared to 2017 increased by 33.33%.

(% of growth, profit ...) = (Next year - Previous year) / Previous year * 100 = the result.

How to calculate the percentage

Calculating a percentage as a percentage is one of the most frequently used percentages. We will calculate the percentage of an individual out of multiple individuals within a particular population. This percentage calculation is actually quite easy to calculate, we just need to divide the total number of individuals and multiply by 100 to get the percentage needed.

Example of calculating% of A and B:

  • Percentage of A = A / (A + B) * 100 (%).
  • Percentage of B = B / (A + B) * 100 (%) or% B = 100 -% A.

We will calculate the percentage of a specific problem as follows. Class 3A has a total of 60 students, of which 20 are good students, 10 are good students and the rest are good students. Calculate the percentage of students who are good, fair and average.

  • % of excellent students: 20/60 * 100 = 33.33%
  • % of students getting good: 10/60 * 100 = 16.67%
  • % of average students: 30/60 * 100 = 50% or 100 - 33,33 - 16,67 = 50%

% of student A = Total students / (Number of students A + Number of students B) * 100

Calculate the percentage of work done

Calculating percent complete is also one of the most simple calculations. The general formula is A / B * 100. Where A is the number achieved and B is the number of targets set. Based on the number achieved and the target number we will calculate the% of work done.

Illustration:

The goal of the Vietnam Athletics Federation at Sea Games 30 is to reach 40 gold medals, in fact the athletics team has won 45 gold medals. Ask the track and field team has completed how many% of the set target.

  • % completion of track and field team = 45/40 * 100 = 112.5%

News athlete athletes team has exceeded the goal and reached 112.5%.

% Achieved = Revenue achieved / Revenue set out * 100

Calculate percentage increase or decrease in price

This percentage calculation is also frequently applied and is especially used when buying and selling items in bulk. People need to calculate carefully to buy the best price. However, the method of increasing and decreasing percentages is different, please refer to the example to get the most accurate calculation.

Percentage discount

Illustrative example: Blood pressure monitor Omron Hem 7120 in the market is 950,000 VND, the price at Meta company is 19% cheaper. Calculate the price of Blood Pressure Monitor Omron Hem 7120 at Meta company.

  • Amount of Omron Hem 7120 biceps blood pressure monitors reduced at Meta = 950,000 * 19/100 = VND 180,500

So the price of Blood Pressure Monitor Omron Hem 7120 = 950,000 - 180,500 = 769,950 VND

Amount reduced = Percentage * Price / 100

Percentage increase

Illustrative example: It is also the Omron Hem 7120 Blood pressure monitor with the tax price of VND 700,000, the VAT of this item is 10%. Calculate the taxed price of the device above.

  • VAT of blood pressure monitor: 700,000 * 10/100 = 70,000 VND

So the price of blood pressure monitor after tax: 700,000 + 70,000 = 770,000 VND

Amount increased compared to cost price = Percentage * Price / 100

How to calculate the percentage of bank interest

It seems that bank interest rates bring a lot of difficulties to those who do not calculate often. But basically the calculation is not complicated at all. Take a look at the example below to learn how to calculate.

Illustration:

The bank interest rate is 7% for 6 month term. Calculate the monthly interest received and the interest after 6 months when you deposit VND 300,000,000.

  • Monthly interest rate = (300,000,000 * 7/100) / 12 = 1,750,000 VND
  • 6-month interest rate = 1,750,000 * 6 = VND 10,500,000

Interest = Deposit amount *% interest rate / 100 * time of deposit / time of deposit

Calculate percentages in Excel , WPS Spreadsheets

It is not uncommon for Microsoft Office Excel to be included here, this office tool helps you to statistic and calculate a lot of different parameters, and of course at some point it will have to calculate the%. Depending on the circumstances, the calculation will be different. Alternatively you can use Spreadsheets of WPS.

However, you can rely on the easiest way is to calculate% to decimals then format% format to display% numbers, more specifically you can follow the way below with WPS SpeardSheets .

Step 1: For example, you are required to calculate the number of% of goods sold, simply divide by the number of sold goods divided by the total number of products ( not multiplied by 100 ).

The fastest and easiest way to calculate percentages (%)

Step 2: At this point, the value you just shared is displayed with the decimal number (less than 1 and greater than 0) , depending on each calculation, it may be greater than 0 and less than 1.

Next, highlight all and right-click it, then choose Format Cells.

The fastest and easiest way to calculate percentages (%)

Step 3: In the Format Cells table , in the Category section , select Percentage to convert the value to a percentage. As for the Decimal Places line, it shows the number rounded after the comma, depending on whether you can choose 2 or 4 numbers so that the value is displayed in detail in the Sample section .

The fastest and easiest way to calculate percentages (%)

Or do not like you can choose the number 0 to round the value and press OK.

The fastest and easiest way to calculate percentages (%)

And we will have the following result.

The fastest and easiest way to calculate percentages (%)

For the remaining percentage of goods, you can subtract 1% from the number of goods sold, and then choose to display the percentage with Format Cells as above.

The fastest and easiest way to calculate percentages (%)

Hopefully the above percentages will help you with your studies and work!

Sign up and earn $1000 a day ⋙

Leave a Comment

Why Checkbox is an underutilized Excel feature?

Why Checkbox is an underutilized Excel feature?

On the surface, Excel Checkboxes seem like a very simple feature - which is probably why they are often overlooked.

Why Excel is the only project management tool you need?

Why Excel is the only project management tool you need?

Many people have tried many project management tools, but still come back to Excel for project management. While it may not be perfect for everyone, it is a simple, yet effective solution that you already know how to use.

Microsoft allows users to use Office applications on Windows for free, but with some limitations.

Microsoft allows users to use Office applications on Windows for free, but with some limitations.

Microsoft recently raised the price of its Microsoft 365 subscription, justifying the change by adding more AI experiences to the service.

TRUNC Function: How to remove decimals and shorten numeric values

TRUNC Function: How to remove decimals and shorten numeric values

There are different ways in Excel to remove decimals and shorten numeric values. In this article, Quantrimang.com will explain how to use the TRUNC function and point out what makes it different from other techniques.

SUBTOTAL Function: Calculates the total value of a filtered list in Excel

SUBTOTAL Function: Calculates the total value of a filtered list in Excel

The sum function when filtering data is very important for Microsoft Excel users. This article will summarize for you how to filter and calculate sum in Excel using Subtotal.

How to Export Airtable to Excel and Google Sheets

How to Export Airtable to Excel and Google Sheets

Airtable lets you create and share relational databases easily. Export your Airtable data to Google Sheets or Excel to enjoy the benefits of advanced charts and data visualization.

Effective ways to use ChatGPT in Excel

Effective ways to use ChatGPT in Excel

Curious about how ChatGPT can enhance your Excel experience? Here are some tips for using ChatGPT in Excel.

How to use the WORKDAY function in Microsoft Excel

How to use the WORKDAY function in Microsoft Excel

In Microsoft Excel, the WORKDAY function is a date and time function and its purpose is to return the date before and after the specified number of working days. Working days do not include weekends or any days defined as holidays.

Why are so many people stopping using Google Sheets and going back to Excel?

Why are so many people stopping using Google Sheets and going back to Excel?

For a while, Google Sheets lured people away from Excel. But many people came back after realizing that Google Sheets is far from beating Excel.

How to use the TREND function in Excel

How to use the TREND function in Excel

You can calculate and visualize trends in Excel using the TREND function. Here's how to use the TREND function in Microsoft Excel.

How to enable and disable macros on Excel

How to enable and disable macros on Excel

The following article will guide readers how to enable and disable macros in Excel 2007, 2010, 2013 and 2016.

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel. Why do some Excel documents not display data or contain blank pages when printed? Below are the reasons

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar, How to pin Office files to the taskbar icon on Windows 11? Invite

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save an Excel file on Windows. If you can't save the Excel file, don't worry too much. Below are ways to fix the error of not being able to save the above Excel file

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel, You can easily insert pictures into Excel spreadsheets and edit them with macro code. Here's how to insert images

Instructions on how to upgrade RAM on PC and laptop

Instructions on how to upgrade RAM on PC and laptop

Installing more RAM is the most effective solution to speed up your computer. Even if your computer is new, after only a few years of use, you will have to install more RAM to ensure better speed. In addition, new operating systems also require more memory. When a computer does not have enough RAM, it will exchange data streams with the hard drive, and that is the reason why your system runs slowly.

Instructions for canceling Gemini Advanced subscription

Instructions for canceling Gemini Advanced subscription

Gemini Advanced is a paid subscription from Google that gives you access to more advanced AI models. After signing up for the Gemini Advanced plan, if you no longer need to use it, you should cancel the Gemini Advanced plan, according to the article below.

Instructions for installing Windows 11 on a virtual machine, installing Windows 11 on VMware

Instructions for installing Windows 11 on a virtual machine, installing Windows 11 on VMware

In this article, WebTech360 will guide you how to install and experience Windows 11 on VMWare virtual machine.

How to group layers in Canva

How to group layers in Canva

Grouping layers in Canva makes your design more professional and also makes it easier to edit and work with your design.

Instructions for turning on communication safety to protect children using iPhone

Instructions for turning on communication safety to protect children using iPhone

Safe Communication will blur sensitive images received on your child's iPhone via Messages, AirDrop. Here's how to use Safe Communication on iPhone.

DTCL Season 14 Marksman Squad, DTCL Season 14 Marksman Build

DTCL Season 14 Marksman Squad, DTCL Season 14 Marksman Build

Marksmen return in TFT season 14 and are still a powerful class with outstanding long-range physical damage.

How to fix sound errors on Windows 10, fix Win 10 sound errors

How to fix sound errors on Windows 10, fix Win 10 sound errors

Some computers after upgrading to Windows 10 version have the problem of losing sound. We can check the audio device connections to the computer, or adjust the sound settings on the operating system.

How to use sounds in ScratchJR

How to use sounds in ScratchJR

In this article students will learn how to add sounds and use sounds in ScratchJR for each of their characters.

Instructions for learning English on ScratchJR

Instructions for learning English on ScratchJR

ScratchJR helps students create command-based programs for characters, and you can use it to build a foreign language learning program on ScratchJR.

How to create and manage iMessage iPhone chat groups

How to create and manage iMessage iPhone chat groups

The iPhone iMessage group chat feature helps us text and chat more easily with many people, instead of sending individual messages.

Instructions for setting nicknames for friends accounts on TikTok

Instructions for setting nicknames for friends accounts on TikTok

TikTok has an option to set a nickname for your friends' accounts to choose a name that is easier to remember in your friend list. This article will guide you to set a nickname for your friends' accounts on TikTok.

Guide to improving services and search in Edge

Guide to improving services and search in Edge

Search and service improvement is a setting in Microsoft Edge that lets the company use your web search data to improve your search and web experience.

Instructions to change Weibo password on phone, computer

Instructions to change Weibo password on phone, computer

Weibo accounts also have options to edit the account, such as changing the Weibo password. Here are instructions for changing the Weibo password.

How to write stylish text on Claude AI

How to write stylish text on Claude AI

Claude AI now allows you to choose from a variety of text writing styles so users get the text they need.

How to recover deleted messages on iPhone, recover iPhone messages fastest

How to recover deleted messages on iPhone, recover iPhone messages fastest

There are several ways to recover deleted messages on iPhone, using iCloud, using iTunes, and using third-party apps.