How to Round Percentages in Excel (4 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working with Microsoft Excel we might find unnecessary decimal numbers with percentages in our dataset. We might need to round those percentages. In this article, I will show you how you can round percentages in Excel.


How to Round Percentages in Excel: 4 Quick Methods

The following methods will cover some quickest ways to round percentages in excel. Stay tuned.

Suppose we have a dataset of some employees’ sales commission in a percentage format. Now we will round the percentages.

Round Percentages in Excel


1. Use ROUND Function to Round Percentages in Excel

Using the ROUND function you can round percentages quickly. Follow the steps below-

Steps:

  • Select a cell (F5).
  • Apply the formula-
=ROUND(D5,4)

Where,

  • The ROUND function returns a number rounded to a given number of digits.

Use ROUND Function to Round Percentages

  • Press Enter to see the result in the selected cell.
  • Drag down the fill handle to get the output in all cells.

Use ROUND Function to Round Percentages

  • Here you will see all the percentages are rounded.

Read More: How to Set Rounding Precision in Excel


2. Utilize ROUNDUP Function to Round Percentages in Excel

Sometimes we might need to round the percentage in a way so that the rounded percentage will show upper values of the whole percentage. For that, you can use the ROUNDUP function in excel.

Steps:

  • Choose a cell. Here I have selected cell (F5).
  • Apply the formula-
=ROUNDUP(D5,4)

Where,

Utilize ROUNDUP Function to Round Percentages in Excel

  • Press Enter.
  • Drag down the fill handle.

Utilize ROUNDUP Function to Round Percentages in Excel

  • Thus we can get our percentages rounded up in excel.


3. Apply ROUNDDOWN Function to Round Percentages in Excel

In the previous method, we have shown how you can round percentages and at the same moment round up the percentages. In this method, we will round down percentages.

Steps:

  • Select a cell to apply the formula. Here I have selected cell (F5).
  • Put the following formula-
=ROUNDDOWN(D5,4)

Where,

  • The ROUNDDOWN function rounds down the digit within a given number.

Apply ROUNDDOWN Function to Round Percentages in Excel

  • Click Enter.
  • Now drag the fill handle down to get the desired output in all cells.

Apply ROUNDDOWN Function to Round Percentages in Excel

  • Here you will see we have successfully rounded percentages with the help of the ROUNDDOWN function.

Read More: Round off Formula in Excel Invoice


4. Increase and Decrease Decimal Feature to Round Percentages in Excel

This method is the simplest way to round percentages just by some single click. You can round percentages with the increase and decrease decimal feature of excel.

Steps:

  • Choose the cells from the dataset to round percentages.
  • In the home, ribbon click 3 times the decrease decimal icon to decrease the decimal and round the percentages.

 Increase and Decrease Decimal Feature to Round Percentages in Excel

  • As you can see clicking the decrease decimal button you can round percentages according to your choice. To increase decimal you can also press the left side icon of increase decimal.

Read More: How to Roundup a Formula Result in Excel


Things to Remember

  • In this part, I will explain to you the main differences between the ROUNDUP and ROUNDDOWN functions.

In this article, check out the result from the ROUNDUP and ROUNDDOWN functions. I have attached both outputs in the following picture-

Difference between ROUNDUP and ROUNDDOWN function

As you can see the ROUNDUP function has rounded up the percentages. On the other hand, the ROUNDDOWN function has rounded down the percentages.


Download Practice Workbook

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


Conclusion

In this article, I have tried to cover the simple and quickest ways to round percentages in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles


<< Go Back to Rounding in Excel | Number Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo