Sometimes, in our **Excel **worksheet, we need to apply the percentage formula in multiple cells to get particular information, or to compare between certain figures. In this article, we’ll show you the simple methods to **Apply **the** Percentage Formula** in **Excel Multiple Cells**.

To illustrate, I’m going to use a sample dataset as an example. Here, the below dataset represents the **Salesman**, **Product**, and **Net Sales **of a company.

## Download Practice Workbook

In order to practice by yourself, download the following workbook.

## What is Percentage?

A **Percentage **is a number or ratio expressed as a fraction of **100**. The symbol of percentage is ‘**%**’. The basic percentage is calculated by the formula:

**Percentage = (Part / Whole)*100**

## 5 Effective Methods to Apply Percentage Formula for Multiple Cells in Excel

### 1. Use Excel Division Symbol and Percentage Format to Apply Percentage Formula in Multiple Cells

We can calculate the percentage in our **Excel **sheets by applying different methods. First, we’ll simply use a division symbol, which is a** Forward Slash** (**/**), and the **Excel Percentage** format to determine the net sales percentage of each **Saleman **of the **Total **sales. For this reason, first, we’ll compute the **Total** by using the **Excel SUM** function.

**STEPS:**

- In the beginning, select cell
**D11**. Here, type the formula:

`=SUM(D5:D10)`

- Next, press
**Enter**.

- Then, select cell
**E5**. There, type the formula:

`=D5/D$11`

- After that, press
**Enter**. And, use the**AutoFill**tool to fill the series.

- Now, select the range of cells to convert to percentage format.

- Next, select the ‘
**%**’ icon in the**Number**group under the**Home**tab.

- In the end, you’ll get your desired percentages.

**Read More: How to Calculate Dividend Growth Rate in Excel (3 Methods)**

### 2. Apply Percentage Formula Manually in Multiple Cells in Excel

Additionally, we can input the formula manually to get the net sales percentage of each salesman of the total. In this case, we just have to multiply with **100**.

**STEPS:**

- First of all, select cell
**D11**. Here, type the formula:

`=SUM(D5:D10)`

- Next, press
**Enter**and it’ll return the**Sum**of**Net Sales**.

- Then, select cell
**E5**. Here, type the formula:

`=(D5/D$11)*100`

- After that, press
**Enter**. And then, use the**AutoFill**tool to complete the series like it’s shown below. - Finally, the accurate results will appear in the column.

**Read More: Percentage Formula in Excel (6 Examples)**

### 3. Excel Percentage Formula in Multiple Cells by Calculating Percentage Differences

Sometimes, we have to compare certain data to get a clear perspective of how the product or service is making an impact on the market or to see improvements. In this method, we’ll compare the **Net Sales** amount in percentage between the years **2020 **and **2021 **for each salesman. Therefore, follow the steps below to learn how we can find out the net sales percentage increase or decrease from the previous year.

**STEPS:**

- At first, select cell
**E5**. Here, type the formula:

`=(D6-C6)/C6`

- Next, press
**Enter**. Then, use the**AutoFill**tool to fill the series.

- After that, select the range of cells to convert them to percent.

- Now, select the ‘
**%**’ icon in the**Number**group under the**Home**tab.

- At last, you’ll get to see the percentage difference in the net sales amount.

**Read More:** **Percentage Difference between Two Percentages Excel (2 Easy Ways)**

**Similar Readings:**

**How to Calculate Gross Profit Margin Percentage with Formula in Excel****Calculate Revenue Growth Rate in Excel (3 Methods)****How to Forecast Growth Rate in Excel (2 Methods)****Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Reverse Percentage in Excel (4 Easy Examples)**

### 4. Excel SUMIF Function for Applying Percentage Formula in Multiple Cells

Often, we have to figure out the contribution of a particular person or product to the total sales amount. For that reason, we can use the **Excel SUMIF** function. Here in this method, we’ll apply the **SUMIF** function to find out the impact in **percentage on the total sales** made by the salesman **Wilham**.

**STEPS:**

- Firstly, select cell
**D11**. Here, type the formula:

`=SUM(D5:D10)`

- Next, press
**Enter**and it’ll return the sum.

- Then, select cell
**G5**. There, type the formula:

`=SUMIF(B5:D10,B5,D5:D10)/D11`

- After that, press
**Enter**. - Now, select the ‘
**%**’ icon in the**Number**group under the**Home**tab.

- Finally, you’ll get
**Wilham’s**contribution to the total sales.

### 5. Percentage Formula with Increasing/Decreasing a Number by Percentage

Lastly, we can also compute the updated net sales amount for any percentage increase or decrease in the previous net sales by creating a formula. In this example, we have a percentage increase amounts in column **E**. Therefore, follow the steps given below to determine the updated net sales.

**STEPS:**

- First, select cell
**F5**. Here, type the formula:

`=D5*(1+E5)`

- Next, press
**Enter**. And then, use the**AutoFill**tool to fill the series. - In the end, the desired outcome will appear like it’s shown in the following picture.

**Read More: How do you Calculate Percentage Increase or Decrease in Excel**

## Conclusion

Henceforth, you will be able to apply **Percentage Formula **in **Multiple Cells **in **Excel **with the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

**Related Articles**

**How to calculate salary increase percentage in Excel [Free Template]****Excel formula to calculate percentage of grand total (4 Easy Ways)****How to Add 20 Percent to a Price in Excel (2 Quick Methods)****Calculate Percentage of a Number in Excel (5 Easy Ways)****How to Use the Exponential Growth Formula in Excel (2 Methods)**