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.

Apply Percentage Formula in Excel Multiple Cells


 

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)

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

  • Press Enter.

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

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

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

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

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

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

  • Select the ‘%’ icon in Number.

This is the output.

Read More: Make an Excel Spreadsheet Automatically Calculate Percentage


Method 2 – Applying a Percentage Formula Manually in Multiple Cells

STEPS:

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

Apply Percentage Formula Manually in Multiple Cells in Excel

  • Press Enter to see the Sum of Net Sales.

Apply Percentage Formula Manually in Multiple Cells in Excel

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

Apply Percentage Formula Manually in Multiple Cells in Excel

  • 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

Percentage Formula in Excel Multiple Cells by Calculating Percentage Differences

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

Percentage Formula in Excel Multiple Cells by Calculating Percentage Differences

  • Select the range of cells to convert to percentage.

Percentage Formula in Excel Multiple Cells by Calculating Percentage Differences

  • Select the ‘%’ icon in Number.

This is the output.

Read More: How to Calculate Percentage for Multiple Rows in Excel


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)

Excel SUMIF Function for Applying Percentage Formula in Multiple Cells

  • Press Enter to see the sum.

Excel SUMIF Function for Applying Percentage Formula in Multiple Cells

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

Excel SUMIF Function for Applying Percentage Formula in Multiple Cells

  • 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)

Percentage Formula in Excel Multiple Cells with Increasing/Decreasing a Number by Percentage

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


Download Practice Workbook

Practice with the following workbook.


 

Related Articles


<<Go Back to Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo