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

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

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

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,

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

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.

• 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-

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

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

Advanced Excel Exercises with Solutions PDF