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

5 ★ | 1 Vote

May be interested

  • Save time with these text formatting functions in Microsoft ExcelSave time with these text formatting functions in Microsoft Excel
    microsoft excel is a main application for anyone who has to work with numbers, from students to accountants. but its usefulness extends beyond a large database, it can do a lot of great things with text. the functions listed below will help you analyze, edit, convert, change text and save many hours of boring and repetitive tasks.
  • SUMPRODUCT function in Excel: Calculates the sum of corresponding valuesSUMPRODUCT function in Excel: Calculates the sum of corresponding values
    the sumproduct function is an extremely useful function when you have to deal with a lot of data numbers in microsoft excel. here are the things you need to know about the sumproduct function in excel.
  • Ways to round numbers in ExcelWays to round numbers in Excel
    to round numbers in excel, we can use different functions, with different rounding types.
  • MINA function in Excel, how to use and examplesMINA function in Excel, how to use and examples
    the mina function in excel helps determine the smallest value in a range of numbers, including logical values ​​and text numbers. with simple syntax, mina supports optimizing the calculation process in spreadsheets.
  • MEDIAN function in Excel, how to use and examplesMEDIAN function in Excel, how to use and examples
    the median function in excel helps you calculate the median of a series of numbers, which is the middle value when the numbers are arranged in ascending order. this is a useful tool in statistics and data analysis.
  • How to Add Autonumber in ExcelHow to Add Autonumber in Excel
    adding numbers automatically to a column in excel can be done in two ways, using the row function or the fill feature. the first method ensures that the cells display the correct row numbers even when rows are added or deleted. the second,...
  • How to use ISEVEN and ISODD functions in ExcelHow to use ISEVEN and ISODD functions in Excel
    identifying even and odd numbers may be easy in small groups of data, but with large amounts of data it is different. luckily, excel provides two built-in functions, iseven and isodd, to simplify this task.
  • Instructions to stamp negative numbers in ExcelInstructions to stamp negative numbers in Excel
    during the spreadsheet process on excel, we will have to work with many types of numbers, including negative numbers. and if you want to differentiate negative numbers from other numbers in the data sheet, you can format close or red brackets to distinguish them.
  • Instructions on how to use the ROUND function in excelInstructions on how to use the ROUND function in excel
    in calculation, the numbers are not always even. so, to make the calculation easier and to shorten the numbers, we will use the round function in excel to round numbers.
  • VAR function - The function of estimating variance based on a sample in ExcelVAR function - The function of estimating variance based on a sample in Excel
    var function: the function performs an estimate of the latter based on a sample from a given set. function arguments can be numbers, names or arrays, or references containing numbers.