Calculating percentages is one of the most common forms of calculation, frequently appearing in many areas of daily life, especially when calculating on Excel. How to calculate percentage in Excel does not have to use Excel functions, but is just regular calculation. So how to calculate percentage fastest, and also most accurately? The article below will guide you how to calculate the most accurate percentage value.
If you want to calculate the percentage without having to read complicated percentage formulas, just enter the corresponding value to be calculated. Online % calculator hereafter:
Different ways to calculate percentage (%).
1. Calculate the percentage
Percentage, a relative value that indicates a percentage of any quantity: 1% is 1/100; Therefore, 100% represents the entire quantity and 200% refers to double the given quantity.
For example1% of 1,000 chickens is equal to 1/100 of 1,000 and is equal to 10 chickens; 20% of 1,000 chickens is 20/100 of 1,000 or 200 chickens. These relationships can be generalized as x = PT/100 where T is the total reference quantity chosen to represent 100% and x is the quantity equivalent to a certain percentage P of T. As So, in the example of 1% of 1,000 chickens, T is 1000, P is 1 and x is 10.
Calculating a percentage of a total is the most common percentage calculation problem in percentage calculations. To calculate the percentage of 1 factor in the total number of factors, you just need to take the number of factors to calculate, divide by the total number of factors, then multiply by 100 to get the result..
Example of calculating % of a and b:
- Percentage ratio of a = a/(a+b)*100(%).
- Percentage ratio of b = b/(a+b)*100(%) or %b = 100 – %a.
For example, we have a warehouse problem of exporting 25 shirts and 35 pants. So what percentage of the total number of exported goods does the export quantity account for?
- % shirt = 25/(25+35)*100 = 41.6%.
- % pants = 100 – 41.6 = 58.4% or % pants = 35/(25+35)*100=58.4%.
Similarly, with more factors, for example: The class has a total of 50 students, the number of good students is 10, the number of good students is 25, the average students are 10, the weak students are 5%, calculated. Percentage of good, good, average, and weak students in the class.
- % good h/s = 10/50 x 100 = 20%
- % good h/s = 25/50 x 100 = 50%
- Average % h/s = 10/50 x 100 = 20%
- % weak h/s = 100 – 20 – 50 – 20 = 10%
- or 5/50 x 100 = 10%.
For example, to calculate the annual percentage interest rate for a capital of 1,600,000,000 with an interest rate of 6%, we use the following formula:
- Interest percentage = (Interest rate x Capital amount) / 100
- Profit percentage = (6 x 1,600,000,000) / 100
- Profit percentage = 96,000,000 / 100
- Profit percentage = 960,000,000
So, the interest rate of 6% per year for a capital of 1,600,000,000 is 96,000,000.
2. Calculate the growth percentage to compare the % difference
Percent growth, also known as growth rate, is a calculation you can use when comparing two values over a certain period of time. A common use of growth percentage is to compare revenue from a particular month in the current year or quarter with revenue achieved during that same month in the previous year or quarter. This helps businesses analyze how well they are performing compared to the previous period and allows identifying what should be improved as a percentage of the business's growth.
You can use a simple equation to calculate growth percentage by comparing results from a previous period, or you can use an additional equation to calculate growth performance average over many time periods.
This type of percentage calculation will calculate the % difference between 2 different values. General formula:
(three)/ax 100 (%)
- In which, b is the number to compare the difference, a is the benchmark for comparison.
For example, with the problem of January revenue being 357 million VND, February revenue is 405 million VND. To calculate the percentage growth of February compared to January, we subtract January's revenue from February to get the result, divide it by January's revenue, then multiply by 100.
% growth in February = (405-357)/357 x 100 = 13.4%.
This % number can be negative in case the next month's revenue is lower than the previous month's, for example, January's revenue is 500 million, February's revenue is 450 million, then we calculate the % difference as -10%. That means February's revenue growth was 10% lower than January's.
The easiest to remember formula for calculating % growth is: (new – old)/old x 100.
3. Calculate the percentage of completion
General formula: a/bx 100where a is the number that has been achieved, b is the number of goals that need to be achieved.
For example, in 2019 Quantrimang.com set a goal of having 5,000 articles on the website. By the end of the first quarter, the number of posts was 1,020. Ask Quantrimang.com how many % of the set goals have been completed?
% of completed QTM = 1020/5000 x 100 = 20.4%.
Thus, by the end of the first quarter, Quantrimang.com completed 20.4% of the set goal.
If at the end of the fourth quarter, the number of articles on Quantrimang.com is 5,200 articles, then % completion = 5200/5000 x 100 = 104%.
To know if the % completion is over or under, you just need to compare it with 100%, if it is greater then the goal is exceeded, if it is smaller then the goal has not been completed. As in the example above, 104%>100% means that QTM not only completed but also exceeded the target by 4%./
4. Calculate percentages in Excel
Excel already has a percentage formula that you don't need to calculate mentally or manually. Users just need to apply the calculation formula. How to calculate percentage in Excel has been given quite detailed instructions, please refer to it.
5. Calculate the percentage discount or increase in price
How to calculate discount percentage
For example, item A at the supermarket has an original price of 1 million 3 hundred thousand VND and is discounted by 7%. So how much must you pay to buy item A after the discount?
We have the calculation of the reduced amount: (1,300,000 x 7) / 100 = 91,000 VND.
So the amount to pay to buy after the discount is 1,300,000 – 91,000 = 1,209,000 VND.
How to calculate price increase percentage
For example, when buying goods worth 270 thousand VND, an additional VTA tax rate of 0.5% will be charged. So what is the actual value of the item after tax?
The increase calculation includes VAT: (270,000 x 0.5) / 100 = 1,350 VND.
So the total amount to pay is 270,000 + 1,350 = 271,350 thousand VND.
6. Calculate bank interest rates
For example, you deposit 213 million VND in the bank with a 6-month term with an interest rate of 5%. Calculate the monthly interest rate received and the interest rate after 6 months deposited in the bank.
The monthly interest rate is
copper
Interest rate after 6 months of deposit is
copper
Above are the percentage calculation types, with common percentage calculation types in everyday life. Depending on each case, you calculate the percentage differently.
How to calculate the percentage of applications in life?
Calculating percentages has many applications in life and different fields. Here are some common applications of calculating percentages:
- Calculate percentage increase/decrease: Percentage is often used to calculate an increase or decrease in a value compared to the original value. This is often applied in finance, commerce, statistics, and business to evaluate situations and trends.
- Calculate percentage ratio: Percentage is also used to calculate the ratio between part and whole. For example, in the social field, percentages can be used to measure population ratio, body mass ratio, or income-to-total income ratio of a group.
- Calculate percentage in statistics: In statistics, percentages are used to represent the distribution of data within a set. It helps to evaluate the correlation and analyze the variables in the sample.
- Calculating percentage in healthcare: Percentages are also used in medicine to express the proportion of a group of people suffering from a disease compared to the total population.
- Calculate percentage in chemistry: In chemistry, percent is often used to express the percentage composition of a substance in a mixture or the mass percentage of a substance in a compound.
The above applications are just some popular examples. Percentage calculation is widely used in many different contexts and plays an important role in measuring, analyzing and comparing data and values.
Wishing you success!