Calculate percentages in Excel, format percentages in Excel

In Excel, there is no formula specifically for calculating percentages of a data table; it can only calculate the percentage of a number. Therefore, you can calculate the percentage of a number by using a regular formula. This article will guide you on calculating percentages in Excel for a number and comparing the percentage ratio between two different numbers.

Calculate percentages in Excel 
 

How to Calculate Percentages in Excel 2007, 2010, 2003, 2013, 2016

Calculate Excel percentages for a number

Specific Example:

We have a provided dataset of numbers. Let's calculate the percentages of these numbers.

- Enter formula in cell D5: =C5*8%. This formula calculates 8% of the value in cell C5.

After pressing Enter, the result is 2980.88, which is the accurate output. You can hold cell D5 and drag down to complete the cells below with the same formula.

Comparing the Percentage Ratio Between 2 Different Numbers in an Excel Data Table

Let's take another example. Here, we will have 3 main columns: Number 1, Number 2, and Ratio. We will calculate the percentage ratio between Number 1 and Number 2.

Firstly, to display results with the unit as %, we will format these cells as percentages. Here's how you can do it:

Step 1: Select the cells in the Ratio column.

Step 2: Right-click and choose Format Cell...

Step 3: In the pop-up dialog, go to the Percentage section. In the Decimal places part, you can choose the number of decimal places if the ratio is not an integer. Then press OK to complete.

- Enter formula in cell E5: =(D5-C5)/C5 or =D5/C5-1. Both formulas are equivalent.

- Press Enter to see the result. The accurate result is 127.348%. You can drag down to complete the cells below.

Here is the guide on how to calculate percentages in Excel. Hopefully, through this article, you will no longer face difficulties in calculating percentages in Excel and can easily apply it to your practical work. In addition to calculating percentages in Excel, you can also multiply the percentage values found through the tutorial on multiplying percentages in Excel that we provided. With the method of multiplying percentages in Excel, you only need to calculate the percentage of one number, and the remaining numbers will be automatically calculated.

If you encounter difficulties during the process, feel free to comment below, and Mytour's technical team will assist you.