# Calculate Percentage of a Number in Excel [4 Cases Explained]

We all know how important it is to know to calculate the percentage for our daily work life. Usage of percentage is almost everywhere, you can’t avoid it. I know some of you may find the percentage a bit disturbing because we can not always remember the basic rule of percentage all the time. The good news is Excel has a percentage feature and some easy formulas to calculate the percentages. Here, I am going to explain **4 cases** to calculate the percentage of a number in Excel.

## Basics of Percentage

In the simplest words, the **Percentage **means parts per 100. 100 is considered the total number when we calculate the percentage. It has no unit and a symbol like **‘%’** is used to express the percentage.

**Percentage = (Part/Total number) x 100 **

To give you an example, **25%** means,

And if, you have 200 books and so far you read 25 books from there. So you have finished reading 12.5% of your books.

## Introduction to the Dataset

Now to show you some scenarios of percentages I have a dataset here with some information about a clothing shop. It has a list of different types of **products **and the **number of products** and amount of **sold products**. We are going to find out the **percentage of sold products**.

## Quickest Way to Calculate Percentage of a Number in Excel

To calculate the percentage of a number in Excel, you can either write down the formula of the percentage or use the **Percentage **option of Excel.

But using the percentage command will be the fastest way to do that.

**Usage Guide**

**Step_1: **Type the following formula in an empty cell (**cell D2**):

**=C2/B2**

**Formula Explanation**

**C2 **is the number of sold products, so it is part of the whole portion. That’s why we will divide the **C2 **by **B2**. Here **B2 **is the number of the full amount. Always keep the small number first and divide that with the bigger number.

**Step_2: **Hit **ENTER**.

This will give you the result of the fraction.

**Step_3: **Select the **Home **tab.

**Step_4: **Inside the **Number **group, click on the **‘%’ **symbol (or press **CTRL+SHIFT+%**).

**Step_5: **Now double-click on the **Fill Handle** ‘**+**’ icon.

**Final Result >**

This turns the results into percentages.

**Note: **This method shows the integer values only. But if you want to increase the decimals, and keep the numbers after the point, you have to follow a few extra steps. To increase the decimals,

**Usasge Guide**

**Step_1: **Select the **Home **tab.

**Step_2: **From the **Number **group, click on the drop-down icon.

**Step_3: **Select the **Percentage **option from the drop-down list.

Now, the percentage has two numbers after the point.

**Step_4: **Copy the formula down to the range of **D2:D9** using the **Fill Handle.**

**Final Result >**

Here is the final result.

**Note: **You can also increase or decrease the decimals by using the decimal commands.

### Alternative Way: Calculate the Percentage of a Number in Excel with Total Amount in a Different Cell

Now, for instance, the dataset has a common total value of all products, unlike the previous scenario.

This time the method will be different.

**Usage Guide**

**Step_1: **Write this formula in cell **C2**:

=B2/$B$10

**Formula Explanation**

**B2 **is the number of T-shirts. We want the **B2 to **be changed in the formula so we have not applied any cell reference here. But we want the **Total **to be fixed in the formula. So we have used the **absolute cell reference** in **B10 **and turned it into **$B$10**.

**Note: **Press **F4 **after typing **B10 **to apply absolute cell reference.

**Step_2: **Press **ENTER**.

**Step_3: **Click on the **Home **tab.

**Step_4: **Click on the** ‘%’ **symbol (or press **CTRL+SHIFT+%**).

**Step_5: **Copy down the formula using the **Fill Handle.**

**Final Result >**

### Case #1: Calculate the Percentage of Various Numbers in Excel

You can calculate the percentage of a number in Excel.

**Usage Guide**

**Step_1: **Write the formula in an empty cell:

**=(B2*A2)**

**Formula Explanation**

**Cell A2 **has the **Percentage(%).** **B2 **has a value of which I want to find the **12%**. The asterisk mark (*) works here as a multiplier.

**Step_2: **Press **ENTER**.

**Step_3: **Double-click on the **Fill Handle** ‘**+**’ icon.

**Final Result >**

This way you can calculate the percentage of a number.

### Case #2: Calculate a Decrease of Percentage in Excel

If you want to decrease a percentage from the total value, there’s a formula for that. For instance, each month you want to invest a percentage of the amount from the monthly revenue. In that case, you have to minus the percentage of investment from the revenue.

**Usage Guide**

**Step_1: **Write this formula in an empty cell:

**=B2*(1-C2)**

**Formula Explanation**

**B2*1** means **B2 **which is the amount of revenue. And **B2*C2 **returns the value of the 12th portion of $25,000. So when subtracting **B2*C2 **from **B2*1 **returns the value of change.

**Step_2: **Press **ENTER**.

**Step_3: **Double-click on the **Fill Handle** icon.

**Final Result >**

**Fill Handle **has copied the formula down to **D2:D10**.

### Case #3: Calculate the Percentage of a Number in Excel with Scattered Parts of a Total

If you are working with a lengthy dataset with repeated product names but different values, you can still find the percentage of a particular repeated product.

We are going to use the **SUMIF** function for this method.

**Usage Guide**

**Step_1: **Write the formula in a separate cell (**D3**):

**=SUMIF(A2:A11,"Top",B2:B11)/$B$12**

**Formula Explanation**

The formula says, range **A2:A11**, is selected to find the product name “**Top**”. Then the function will sum up the number of **Top **from range **B2 **to **B11**. Then the sum-up value will be divided by **B12 **(total value).

**Step_2: **Press **ENTER**.

**Step_3: **Select the ‘**%**’ symbol from the **Number **group.

**Final Result >**

You will get the result in percent (**%**) after that.

### Case #4: Calculate an Increase of Percentage in Excel

This method is similar to calculating a decrease in percentage. You just need to modify the formula a bit.

**Usage Guide**

**Step_1: **Type the following formula in cell **D2**:

**=B2*(1+C2)**

**Step_2: **Press **ENTER**.

**Step_3: **Click on the **Fill Handle** icon.

**Final Result >**

Here is the final outcome of the formula.

## Conclusion

I have tried to show you the most used formulas in Excel. But there are many other formulas for percentages. I hope you have found what you are looking for in my article. Let us know how you like this blog. Thank you.

**Related Articles**

**How to Calculate Total Revenue in Excel [Free Template]****How to Calculate Profitability Index in Excel [Free Template]****How to Find Interquartile Range (IQR) in Excel [Free Calculator]****2 Ways to Calculate Cumulative Frequency in Excel****Calculate 3 Types of Profit Margin in Excel****2 Ways to Calculate Percentage Increase in Excel**