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.


Download Practice Workbook

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


4 Quick Methods to Round Percentages in Excel

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,

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: Rounding to Nearest Dollar in Excel (6 Easy Ways)


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.

Read More: How to Remove Decimals in Excel with Rounding (10 Easy Methods)


Similar Readings


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 (9 Quick Methods)


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 (4 Easy Methods)


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.


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

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo