How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard

In the process of processing data in Excel, there are many cases where you need to calculate the percentage in Excel but you don't know how to calculate it? So, let's refer to the fastest and most accurate percentage calculation in Excel that the article shares below.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 1

This article will guide the fastest and most accurate percentage calculations in Excel, please follow along and use the appropriate percentage method to process your data.

Calculate the percentage of a total

Assuming you have a turnover of 120 million VND a month, this revenue is the total sales of 3 stores. You need to calculate the percentage of each store's sales to total sales.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 2

In cell F11 you enter = E11 / E8 and press F4 to fix the total revenue box you will get the formula = E11 / $ E $ 8.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 3

You will see the result is a decimal, to convert the format to percentage (%), select the cell and select Home -> Format% in the Number section.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 4

So you will get a percentage of CH1 in the total revenue of 42%, you copy the formula to the boxes below to calculate the percentage of CH2 and CH3.

Note: Because you have fixed the total revenue cell, when copying the formula, this cell will be preserved.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 5

Calculates the percentage of change between two numbers

Suppose Company A has a turnover in 2016 of $ 250,000 and a turnover in 2017 of $ 347,000. Calculates the percentage of revenue change between two years.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 6

To make this request, you enter the formula = (E8 / D8) -1 or = (E8-D8) / D8

In which E8 is the revenue in 2017, D8 is the revenue in 2016.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 7

You will get a decimal, to switch to the percentage format, select the resulting cell and select Home -> select the% format in the Number section.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 8

As such, you'll see the percentage change between 2017 and 2016 is 39%.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 9

Calculate the percentage of a number

Assuming you have the price of an iPhone X of 29 990 000 VND, the store applies a 5% discount for customers. You need to calculate 5% of what is 29 990 000.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 10

You enter the formula = C8 * 5% with C8 is the original price of Iphone X, so you will see the results.

How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard Picture 11

Above are some of the fastest and most accurate percentage calculations in Excel, you can calculate a data table with lots of records quickly. Hope this article will help you. Good luck!

4 ★ | 1 Vote

May be interested

  • ABS function (absolute value calculation) in ExcelABS function (absolute value calculation) in Excel
    when you need to calculate absolute values ​​for numbers in excel spreadsheets, you can use the abs function to calculate. the abs function helps you calculate the absolute value of a number, an expression or reference containing a number.
  • Calculate data in a PivotTable in ExcelCalculate data in a PivotTable in Excel
    calculate data in a pivottable in excel. creating statistical reports using pivottable mainly through numbers: summing up quantity, highest sales, lowest ... therefore, the calculation in pivottable is based on calculating numbers.
  • Problem with % units in CSSProblem with % units in CSS
    do you know how to use % units in css? do you have any problems using percentages in css? let's find out with tipsmake.com.com!
  • MS Excel 2007 - Lesson 6: Calculation in ExcelMS Excel 2007 - Lesson 6: Calculation in Excel
    excel supports many calculation functions, logic functions for calculating, filtering, collating and analyzing data. this is also a feature that makes excel an indispensable tool for office jobs. in this article, tipsmake.com will show you how to use the overview calculation function in excel 2007.
  • How to calculate network bandwidth and transmission requiredHow to calculate network bandwidth and transmission required
    finding a way to calculate bandwidth is important to make sure your network runs smoothly and it's best to get the right formula from the beginning. different bandwidth requirements between networks and proper bandwidth calculation are important to build and maintain a fast internet.
  • How to calculate the total value based on multiple conditions in ExcelHow to calculate the total value based on multiple conditions in Excel
    to calculate conditional sum in excel, it is impossible not to mention the special calculation function that is sumif and sumifs function. software tips will guide how to use conditional sum function. please follow the following article.
  • How to use subtraction in ExcelHow to use subtraction in Excel
    subtraction in excel is a basic calculation, which is used a lot in excel calculation exercises.
  • Instructions for calculating total lines and columns in Word 2013Instructions for calculating total lines and columns in Word 2013
    if you are working in word and need to calculate the value of an expression, you can do simple calculations such as summarizing, multiplying, and calculating the average value on the word without copying. data into excel to calculate and paste the results into word.
  • Use the cumulative interest calculation function in ExcelUse the cumulative interest calculation function in Excel
    the following article details how to calculate accrued interest in stocks by excel. in stock, there are 2 methods to pay interest at maturity or to pay interest periodically.
  • The fastest way to calculate lines and columns in Word 2013The fastest way to calculate lines and columns in Word 2013
    you often use excel to calculate data in tables, but if that data is in a word document, you can also perform calculations directly in word without spending time using applications. use calculator support.