How To Calculate Percentage In Excel

How To Calculate Percentage In Excel

clickHere
Rashmi Karan
Manager - Content
Updated on Oct 27, 2023 17:53 IST

Percentages are a very powerful tool for data analysis. They can be used to make data more concise, easier to understand, and more comparable. In this tutorial, we will learn how to find the percentage in MS excel.

The calculation of percentages is a crucial element of data analysis. Excel allows us to work with percentages within our spreadsheets efficiently. In this article, we will learn different techniques to calculate percentage in Excel.

Content

Must Read – What is MS Excel?

What is Percentage?

A percentage is a mathematical entity. It represents a proportion of a given part as a fraction of 100 equal parts. The symbol % denotes the percentage. It must be written after the value it refers to.

Percentages are a powerful tool for data analysis. They can be used to compare different data sets, track trends over time, and identify outliers. By understanding how percentages work, you can use them to make informed decisions and to better understand the world around you.

Percentage Formula in Excel

You can enter a percentage in the cells using the percentage symbol (%). Excel will correctly identify it as a numerical value. The percentage formula in Excel is –

=> (Part/Whole)*100 = Percentage

The basic percentage formula applied by Excel is

= Numerator/Denominator

Let’s understand different techniques to calculate percentages under different scenarios.

Must Explore – Free MS Excel Courses

Calculate Marks Percentages In Excel

To calculate the percentage in Excel, we take the below datasheet. Here, we have marks obtained by a set of students. The maximum mark is 600. We need to calculate how much an individual student obtained.

To add the marks, we will use the SUM function

Now, we will calculate the percentage obtained by the students using –

=Marks obtained/Total marks (=H2/I2)

Once you auto-fill in, the formula applies to all the selected cells. You get the percentage secured by all the students.

How to Use HLOOKUP in Excel
The HLOOKUP in Excel enables finding data in a dataset horizontally. HLOOKUP stands for Horizontal and searches for a value in the top row of a table. The function then...read more
Tutorial – VLOOKUP in Excel – Shiksha Online
VLOOKUP, or vertical lookup, is one of Excel’s most commonly used functions for data analysis. This function belongs to the Search and Reference group, which has other search functions in...read more
Data Validation in Excel – Shiksha Online
Data validation in Microsoft Excel is a feature that allows you to control what can be entered into a cell or range of cells. It helps ensure that data entered...read more

Sometimes, we need to increase an amount by a certain percentage. For example – there is a data set of a few vehicles to be launched in the market. In Column C, there is the cost of a vehicle before taxes.

We have to add a certain percentage of tax to every product as regulated. The tax is 0.2 times for some vehicles, while for some, it is 0.3 times. We will fill in the column with the taxes that need to be added to the cost of the vehicle.

To convert taxes into percentages, select the entire taxes column. Click the % symbol located in the Number section of the Ribbon.

Now we know the percentage of taxes to be added to the cost. We must add that percentage to the original value to obtain the final price of some products after taxes.

To add percentages in Excel, we use the formula

=C2 (cost of the vehicle)*(1+D2 {Percentage to be added})

=C2*(1+D2)

Press Enter.

Autofill all the remaining cells

We obtained the products’ values in the above dataset after adding the taxes. This example should help you to understand how to add percentages to your dataset and get a final value.

Types of Charts in Excel – Shiksha Online
MS Excel offers you a range of options to present your data in the most presentable formats. Different types of charts suit your purpose. You can create a chart Based...read more
How to Create a Graph in Excel – Shiksha Online
How to Choose the Right Chart in Excel?
The article helps you in choosing the right chart for an effective data visualization to achieve business goals.

Subtract Percentages In Excel

If we need to subtract a percentage, the operation will be very similar to the previous one.

Let’s take an example of a product where we have a discount of 20% & 30%. We want to subtract this percentage from the original price. We will use the below formula to calculate the discount –

=C2*(1-D2)

Press Enter

Again, fill in the rest of the cells in the column.

We now have the final price of the vehicles after the mentioned discounts.

Must Explore – MS Excel Courses

Percentage Change

If you want to calculate the percentage change between two numbers, follow the below steps –

1. There is data in Column A. Add new numbers in Column B.

2. Apply the formula

=(B2-A2)/A2

3. Press Enter

4. Fill the rest of the cells using the autofill feature.

You get the percentage change in the original numbers.

Note – The results will be dynamic since we have formulas applied in all the cells. Select all the data, and click on Paste Values. This way, the formula will be removed, and you will get the clean data.

Excel provides a variety of ways to calculate percentages. You must know how to calculate percentages in Excel to get the most out of the tool. The best method will depend on your spreadsheet’s specific needs. By understanding the different ways to calculate percentages in Excel, you can easily perform complex data analysis tasks.

FAQs

How do I calculate the percentage of the total?

To calculate the percentage of a total, divide the part by the total and multiply the result by 100. For example, if you want to calculate the percentage of students who passed a test, you would divide the number of students who passed by the total number of students who took the test.

How do I calculate the percentage of change between two numbers?

To calculate the percentage of change between two numbers, subtract the smaller number from the larger number and divide the result by the smaller number. Multiply the result by 100 to get the percentage of change.

How do I create a pie chart to show the percentage distribution of a group of numbers in Excel?

To create a pie chart to show the percentage distribution of a group of numbers in Excel, select the range of cells containing the numbers you want to chart and then click on the "Insert Pie or Doughnut Chart" button in the "Charts" group on the Insert tab.

How do I create a bar chart to show the percentage change between two number groups in Excel?

To create a bar chart to show the percentage change between two groups of numbers in Excel, select the range of cells containing the numbers you want to chart and then click on the "Insert Clustered Column Chart" button in the "Charts" group on the Insert tab.