How to Divide a Value to Get a Percentage in Excel (5 Suitable Examples)

If you are looking for some special tricks to divide in Excel to get a percentage, you’ve come to the right place. In Microsoft Excel, there are numerous ways to divide in Excel to get a percentage. In this article, we’ll discuss five ways to divide in Excel to get a percentage. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


5 Suitable Examples to Divide a Value to Get a Percentage in Excel

We will use five effective and tricky ways to divide in Excel to get a percentage in the following section. This section provides extensive details on five ways. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.


1. Divide by Copying a Formula to Get a Percentage in Excel

It is the quickest and simplest way to divide in Excel to get a percentage. Here, we have a dataset containing different student marks. We must follow the following process if we wish to calculate each student’s percentage of marks.

Divide in Excel by Copying a Formula to Get a Percentage

📌 Steps:

  • Firstly, we will use the following formula in the cell F5:

=(C5+D5)/E5

Here, cells C5, and D5 show the marks of each student. The Total Marks are shown in cell E5.

  • Press Enter.

Divide in Excel by Copying a Formula to Get a Percentage

  • Next, go to the Home tab, and select the Percentage symbol under the Number group.

  • Consequently, we can convert the data into percentage terms.

Divide in Excel by Copying a Formula to Get a Percentage

  • After that, drag down or double-click the Fill Handle icon to use Excel’s AutoFill feature.
  • Finally, we will get the percentage values in the corresponding cells.

Divide in Excel by Copying a Formula to Get a Percentage

Read More: Division formula in Excel for multiple cells


2. Divide Using Array Formula in Excel

Here, we use another effective way to divide in Excel to get a percentage using array formulas. You have to follow the following steps to do this.

📌 Steps:

  • Firstly, we will use the following formula in the cell F5:

=(C5:C10+D5:D10)/E5:E10

Here, the range of cells C5:C10, and D5:D10 show the marks of each student. The total marks are shown in the range of cells E5:E10.

  • Press Enter.

Divide in Excel Using Array Formula 

  • Next, go to the Home tab, and select the Percentage symbol under the Number group.

Divide in Excel Using Array Formula 

  • Finally, we will get the percentage values in the corresponding cells.

Read More: How to divide columns in Excel (Top 8 easy & quick ways)


3. Divide Using a Constant Number to Get a Percentage

Here, we use another effective way to divide in Excel to get a percentage. We are going to divide the column’s values by a constant number. You have to follow the following steps to do this.

📌 Steps:

  • Firstly, we will use the following formula in the cell F5:

=(C5+D5)/200

Here, cells C5, and D5 show the marks of each student. The Total mark is 200.

  • Press Enter.

Divide Using a Constant Number to Get a Percentage

  • Next, go to the Home tab, and select the Percentage symbol under the Number group.

Divide Using a Constant Number to Get a Percentage

  • Consequently, we can convert the data into percentage terms.

  • After that, drag down or double-click the Fill Handle to use Excel’s AutoFill feature.
  • Finally, we will get the percentage values in the corresponding cells.

Divide Using a Constant Number to Get a Percentage

Read More: How to Add and Then Divide in Excel (5 Suitable Examples)


4. Using Absolute Cell Reference in Excel

Now, we use another quickest way to divide in Excel to get a percentage. We are going to divide the column’s values by a constant number using cell absolute reference to get a percentage. You have to follow the following steps to do this.

📌 Steps:

  • Firstly, we will use the following formula in the cell F5:

=(C5+D5)/$E$7

Here, cells C5, and D5 show the marks of each student. The Total marks are shown in cell E7.

  • Press Enter.

Using Cell Absolute Reference

  • Next, go to the Home tab, and select the Percentage symbol under the Number group.

Using Cell Absolute Reference

  • Consequently, we can convert the data into percentage terms.

Using Cell Absolute Reference

  • After that, drag down or double-click the Fill Handle icon to use Excel’s AutoFill feature.
  • Finally, we will get the percentage values in the corresponding cells.

Read More: How to Divide One Column by Another in Excel (7 Quick Ways)


5. Divide by Utilizing Paste Special Command to Get a Percentage

Now, we use another quickest and most effective way to divide in Excel to get a percentage. We are going to divide the column values by a constant number using the paste special option to get a percentage. You have to follow the following steps to do this.

📌 Steps:

  • Firstly, select the range of the data C5:C10 and press ‘Ctrl+C’.

Divide in Excel Utilizing Paste Special Option to Get a Percentage

  • Then, on the percentage column press Ctrl+V’ or you have to right-click, and select the appropriate paste type like the following.

Divide in Excel Utilizing Paste Special Option to Get a Percentage

  • The percentage column will look like this after pasting the data.

  • Copy the cell D7 by pressing Ctrl+C’.

Divide in Excel Utilizing Paste Special Option to Get a Percentage

  • Next, select the range of the data C5:C10 and you have to right-click. Then click on the Paste Special option.

Divide in Excel Utilizing Paste Special Option to Get a Percentage

  • When the Paste Special dialog box appears, click on the Divide option under the Operation. Click on OK.

Divide in Excel Utilizing Paste Special Option to Get a Percentage

  • As a consequence, you will get the following output.

  • Next, go to the Home tab, and select the Percentage symbol under the Number group.

Divide in Excel Utilizing Paste Special Option to Get a Percentage

  • Finally, we will get the percentage values like the following.

Divide in Excel Utilizing Paste Special Option to Get a Percentage

Read More: How to Divide in Excel for Entire Column (7 Quick Tricks)


Conclusion

That’s the end of today’s session. I strongly believe that from now you may be able to divide in Excel to get a percentage. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib Ahmad Shuvo

Saquib Ahmad Shuvo

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo