How To Calculate Percentage In Excel

Calculating percentages in Excel is a task we often perform while dealing with data analysis. The ability to calculate percentages is a crucial skill, especially when dealing with financial data. This blog post teaches you how to calculate percentages in Excel in the simplest way.

Basic Percentage Formula

The basic formula for calculating percentage in Excel is:

cell1 = (part / total) * 100

In this formula,

  • part refers to the number that you want to find the percentage of.
  • total refers to the total or whole number.

Steps to Calculate Percentage

Step 1: Insert Your Data

First, input your data into cells in an Excel spreadsheet. For example, let’s say we have two numbers: 45 (part) and 200 (total). We can put these numbers into cells A1 and B1, respectively.

Step 2: Apply the Formula

Next, apply the basic percentage formula mentioned above to these cells. In a new cell (C1), you would input the formula as follows:

C1 = (A1 / B1) * 100

Step 3: Press Enter

After typing this formula into cell C1, press Enter. Excel will then perform the calculation and display the result in cell C1.


And there you have it! You have now learned how to calculate percentages in Excel. Remember: Excel is a powerful tool for data analysis, and knowing how to perform basic calculations like this one can save you a lot of time and effort.