# How to Calculate the Percentage Automatically in an Excel Spreadsheet – 2 Methods

## Method 1 – Using an Excel Formula to Automatically Calculate the Percentage

### 1.1 Using the Conventional Percentage Formula

The dataset showcases the total number of COVID-affected patients and the number of deaths in America.

Steps:

• Select C8.
• Double-click the cell and enter the following formula:
`=C5/C6`

• Press Enter.
• A decimal number is displayed in C8.
• Format the value.

• Select C8, and go to the HomeÂ tab.
• Select Number and click % .

• The value is in percentage format.
• Change the number of decimal points by clicking the increase/decrease decimal button below %.

### 1.2 Applying the Excel IFERROR Function

Use the IFERROR function to avoid errors. The dataset contains the exam mark sheet of four students.

Steps:

• There are 2 cells with a value of 0.
• Double-click E5 and enter the following formula:
=IFERROR(C5/D5,0)

• Press Enter to see theÂ result.
• Drag down the Fill Handle.

This is the output.

### 1.3 Calculating the Percent Increase or Decrease Automatically

Steps:

• Select E5 and use the following formula:
=(D5-C5)/C5

• Press Enter to see theÂ result.
• Drag down the Fill Handle.

This is the output.

## Method 2 – Auto Calculating Percentage of Contiguous Cells in an Excel Spreadsheet Using Absolute Reference

Use the absolute reference method.

Steps:

• Click D5 and use this formula:
=C5/\$C\$9
• You can also press F4 to enter the dollar sign in C9.

• Press Enter to see theÂ result.
• Format the decimal places.

• Drag down the Fill Handle.
• The second cell reference is in C9 for all the cells below.

This is the output.

## Related Articles

<<Go Back to Calculating Percentages in Excel

Get FREE Advanced Excel Exercises with Solutions!
Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitorsâ€™ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF