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!

Isabella Humphrey

Update 19 May 2020

You should read it

May be interested

Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts
keyboard shortcut in excel, how to delete lines in excel with keyboard shortcuts. normally, when working with excel if you want to delete a certain line, you will select all the rows then right-click and select delete. but instead of manipulating the mouse you have t
How to read the amount in words in Excel
how to read the amount in words in excel. in the process of working and processing data in excel, you need to convert the amounts into words in excel. if the list of amounts needs to be converted to low letters, you can enter the word for the amount.
How to filter duplicate data from 2 Sheets in Excel
how to filter duplicate data from 2 sheets in excel. in excel file, you have data in 2 different sheets but you want to filter duplicate data with a large number of records. here's how to use the vlookup function to filter duplicate data from 2 sheets in exc
How to quickly save all pictures in Word file into a separate folder
how to quickly save all pictures in word file into a separate folder. for some reason you want to quickly save all images in word files into a separate folder to get the images used. so, please refer to the following article for ways to save her images
How to format numbers in Excel
how to format numbers in excel in the process of working, processing data in excel sometimes you need to format numbers in excel so that data can display the number format in accordance with the requirements to be processed. you do not know how to format numbers in ex
How to create page breaks and page breaks in Excel
how to create page breaks and page breaks in excel. page breaks in excel make it easy to choose to print an area or any data range. in this article, you can create page breaks and page breaks on excel spreadsheets to help you print easily.