How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function
If you don't want to display decimal values in Excel, you can simplify your numeric data with ROUND functions. Excel provides three functions: ROUND, ROUNDUP, and ROUNDDOWN. Let's see how they work.
Using ROUND functions in Excel is different from changing the format of a number. When you change the way a number is formatted, you only change the way it looks in the workbook. When you change numbers using ROUND functions, you change the way they look and are stored.
The ROUND function rounds a number to a specified number of decimal places. It rounds a number down if the digit to the next decimal place to the right is between 0 and 4, and it rounds up if the digit is five to nine. And as you might expect, the ROUNDUP function always rounds and the ROUNDDOWN function always rounds down.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 1
The ROUND function in Excel rounds a number to a specified number of digits. The ROUND function rounds up or down. 1, 2, 3 and 4 are rounded down. 5, 6, 7, 8 and 9 are rounded up.
How to round integers in Excel using the Round function
1. For example, round a number to three decimal places.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 2
Note: 114,726 1 , 114,726 2 , 114,726 3 and 114,726 4 are rounded down to 114,726 and 114,726 5 , 114,726 6 , 114,726 7 , 114,726 8 and 114,726 9 are rounded down to 114,727.
2. Round a number to two decimal places.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 3
3. Round a number to one decimal place.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 4
4. Round a number to the nearest integer.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 5
5. Round a number to the nearest 10.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 6
6. Round a number to the nearest 100.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 7
7. Round a number to the nearest 1000.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 8
8. Round negative numbers to one decimal place.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 9
9. Round negative numbers to the nearest integer.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 10
How to round up in Excel using the RoundUp function
1. For example, round a number up to three decimal places.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 11
Note: 114,726 1 , 114.726 2 , 114.726 3 , 114.726 4 , 114.726 5 , 114.726 6 , 114.726 7 , 114.726 8 and 114.726 9 rounded up to 114,727.
2. Round a number up to two decimal places.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 12
3. Round a number up to one decimal place.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 13
4. Round a number up to the nearest integer.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 14
5. Round a number up to the nearest 10.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 15
6. Round the number up to the nearest 100.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 16
7. Round a number up to the nearest 1000.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 17
8. Round negative numbers up to one decimal place.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 18
Note: remember, the ROUNDUP function rounds numbers up (away from zero).
9. Round negative numbers up to the nearest integer.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 19
Note: again, the ROUNDUP function rounds the number up (away from zero).
How to round down in Excel using the RoundDown function
The ROUNDDOWN function in Excel always rounds numbers down (to zero). 1, 2, 3, 4, 5, 6, 7, 8 and 9 are rounded down.
1. For example, round a number down to three decimal places.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 20
Note: 114,726 1 , 114,726 2 , 114,726 3 , 114,726 4 , 114,726 5 , 114,726 6 , 114,726 7 , 114,726 8 and 114,726 9 are rounded down to 114,726.
2. Round a number down to two decimal places.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 21
3. Round a number down to one decimal place.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 22
4. Round a number down to the nearest integer.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 23
5. Round the number down to the nearest 10 numbers.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 24
6. Round a number down to the nearest 100.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 25
7. Round a number down to the nearest 1000.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 26
8. Round negative numbers down to one decimal place.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 27
Note: remember, the ROUNDDOWN function rounds a number down (to zero).
9. Round negative numbers down to the nearest integer.
How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function Picture 28
Note: again, the ROUNDDOWN function rounds a number down (to zero).
You should read it
- Round a number in Excel (ROUND function)
- How to Round in Excel
- Round a number in Excel
- The round () function in Python
- Ways to round numbers in Excel
- ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel
- Instructions for rounding decimal numbers after commas in Excel
- Round function, how to use rounded functions in Excel
- ROUND function in SQL Server
- How to Convert from Binary to Decimal
- The INT (Function rounds a number down to the nearest integer of a number) in Excel
- TIMEVALUE function - The function returns the decimal number of time expressed as a text string in Excel
May be interested
4 ways to import data from websites into Google Sheets
The best timesheet templates for you to track daily work
Instructions for inserting a countdown timer in Google Slides
Instructions for creating Word Cloud in Google Slides
Top best PDF reading software 2023 for free on PC, laptop
How to quickly Add and Delete rows and columns in Excel