# How to Apply a Percentage Formula in Multiple Cells in Excel – 5 Methods

The sample dataset showcases Salesman, Product, and Net Sales of a company.

### Method 1 – Using the Excel Division Symbol and the Percentage Format to Apply the Percentage Formula in Multiple Cells

STEPS:

• Select D11. Enter the formula:
`=SUM(D5:D10)`

• Press Enter.

• Select E5. Enter the formula:
`=D5/D\$11`

• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

• Select the range of cells to convert to percentage format.

• Select the ‘%’ icon in Number.

This is the output.

### Method 2 – Applying a Percentage Formula Manually in Multiple Cells

STEPS:

• Select D11. Enter the formula:
`=SUM(D5:D10)`

• Press Enter to see the Sum of Net Sales.

• Select E5. Enter the formula:
`=(D5/D\$11)*100`

• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

### Method 3 – Using an Excel Percentage Formula in Multiple Cells by Calculating the Percentage Differences

• Select E5. Enter the formula:
`=(D6-C6)/C6`

• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

• Select the range of cells to convert to percentage.

• Select the ‘%’ icon in Number.

This is the output.

### Method 4 Using the Excel SUMIF Function to Apply a Percentage Formula in Multiple Cells

You want to find Wilham’s impact in the percentage of the total sales.

STEPS:

• Select D11. Enter the formula:
`=SUM(D5:D10)`

• Press Enter to see the sum.

• Select G5. Enter the formula:
`=SUMIF(B5:D10,B5,D5:D10)/D11`

• Press Enter.
• Select the ‘%’ icon in Number.

• Wilham’s contribution to the total sales is displayed.

### Method 5- Using an Increasing/Decreasing Percentage Formula

STEPS:

• Select F5. Enter the formula:
`=D5*(1+E5)`

• Press Enter. Drag down the Fill Handle to see the result in the rest of the cells.
• This is the output.

Practice with the following workbook.

## Related Articles

<<Go Back to Calculating Percentages in Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF