# How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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

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

### 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 Salesman 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. ### 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. Then, use the AutoFill tool to complete the series like it’s shown below.
• Finally, the accurate results will appear in the column. ### 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. ### 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. 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. ## 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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. Aung Shine

My name is Aung. I have my B.Sc. degree in EEE. From now on, I will be working with Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  