# 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.

## Conclusion

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.