# 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.

## 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. ### 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, • Press Enter to see the result in the selected cell.
• Drag down the fill handle to get the output in all cells. • Here you will see all the percentages are rounded. ### 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, • Press Enter.
• Drag down the fill handle. • 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. • Click Enter.
• Now drag the fill handle down to get the desired output in all cells. • Here you will see we have successfully rounded percentages with the help of the ROUNDDOWN function. ### 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. • 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. ## 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- 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

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 Advanced Excel Exercises with Solutions PDF  