# How to Round Off Numbers in Excel (10 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Excel works tremendously well especially regarding mathematical calculations. It has a large number of built-in functions which helps to do complicated mathematical functions quite easily. One frequently used mathematical calculation is to Round Off Numbers which can be done by several methods in Excel. In this article we will show 10 simple methods to round off numbers in Excel.

## 10 Easy Methods to Round Off Numbers in Excel

We made a dataset to Round Off Numbers which includes some items and their price having 3 decimal values. We will round the price value with 10 simple and easy methods. ### Method 1: Round Off Numbers Using ROUND Function

We can use the ROUND Function of Excel to round the number. Let’s follow the steps given below.

• First, select cell D5 and write the following formula there.
`=ROUND(C5,2)`
• Next, hit Enter.
• Then, use Fill Handle to copy the formula in the cells below. In the formula the ROUND function rounds up the value of cell C5 upto 2 decimals.

### Method 2: Apply ROUNDUP Function in Excel

The ROUNDUP function of Excel can be used also which rounds a number by increasing the decimal value. Let’s follow the steps given below to use the function for rounding off numbers.

• First, select cell D5.
• After that, write the following formula in the cell
`=ROUNDUP(C5,1)`
• Next, hit Enter.
• Finally, use Fill Handle to copy the formula in the cells below. Here, the ROUNDUP function takes the value of cell C5 and increases its decimal value by 1.

### Method 3: Number Rounding with ROUNDDOWN Function

The ROUNDDOWN function can also be used to round down numbers. The function decreases the decimal value according to the argument given. We are showing the steps below to round off numbers using the ROUNDDOWN function.

• Let’s select cell D5 first.
• Then, write the following formula in the cell.

`=ROUNDDOWN(C5,1)`

• Next, press Enter.
• Later on, use Fill Handle to copy the formula in the cells beneath. The formula used the ROUNDDOWN function to round the value of cell C5 upto 1 decimal and it cuts the further decimal values.

### Method 4: Excel MROUND Function to Round Off Numbers

Excel has the MROUND function which can also round numbers. Let’s follow the steps given below to round a number in Excel.

• Firstly, select cell D5 and write the following formula in the cell
`=MROUND(C5,1)`
• Now, press Enter.
• Finally, use the AutoFill option to copy the formula in the following cells. In the formula, the MROUND function discards the decimal values and rounds the number by closest integer.

### Method 5: Make Use of FLOOR Function in Excel

We can use the FLOOR function of Excel to round numbers. The FLOOR function rounds the number as a multiple of another number which is given in argument. We are showing the steps to use this function to round off numbers.

• First, select cell E5 and write the formula given below.
`=FLOOR(C5,D5)`
• Now, hit Enter.
• Finally, use the Fill Handle to copy the formula in the following cells. The FLOOR function here converts the value of cell C5 as a nearest lower value which is a multiple of value from cell D5.

### Method 6: Insert CEILING Function for Rounding Off Numbers

The CEILING function also works similar to the FLOOR function but it gets the nearest upper multiple of a number of significance which is given in the argument. The steps to use the CEILING function for rounding off numbers are given below.

• At the starting, select cell E5 and write the following formula there.
`=CEILING(C5,D5)`
• Then, hit Enter.
• Next, use the AutoFill option to copy the formula in the cells following.
• Finally, we can see the round off price in the range of cells E5:E10. Here, the CEILING function rounds the value of cell C5 by the nearest upper multiple of value of cell D5.

### Method 7: Application of INT Function in Excel

The INT function of Excel also rounds off a number just fine. This function discards the decimal value of a number and gives the integer value as output. The steps to use the function to round off numbers are given below.

• Select cell D5 and write down the formula given below.
`=INT(C5)`
• Further, press Enter.
• Lastly, use the Fill Handle to copy the formula in the following cells. In the formula, the INT function gets the integer value of cell C5 discarding the decimal value.

### Method 8: Excel EVEN & ODD Functions to Round Off Numbers

We can also use the EVEN function and the ODD function to round off numbers. The ODD function takes a number and increases its value to the nearest odd number whereas the EVEN function increases the number up to the nearest even number. The steps to use these functions to round off numbers are given below.

#### For ODD Function

• First, select cell D5 and write the formula given below in the cell.
`=ODD(C5)`
• Next, hit Enter.
• Further, use the Fill Handle to copy the formula in the following cells. In the formula the ODD function takes the value of cell C5 and converts it to the nearest odd integer.

#### For EVEN Function

• First, select cell E5.
• Next, write the following formula in the cell.
`=EVEN(C5)`
• Then, press Enter.
• Finally, use the AutoFill option to copy the formula in the following cells. The EVEN function takes the value of cell C5 and increases it to the nearest even integer.

### Method 9: Use TRUNC Function for Rounding Numbers

The TRUNC function works just fine to round off numbers in Excel. In the following section we will discuss the steps to use the TRUNC function to round off numbers.

• Select cell D5.
• Next, write the formula given below.
`=TRUNC(C5,2)`
• Then, hit Enter.
• Further, use the Fill Handle to copy the formula in the cells below. In the formula, the TRUNC function takes the value of cell C5 and discards the decimal value after 2 decimals(as 2 is in the argument).

### Method 10: Apply Functions from Math & Trig Option

So far we wrote down the functions in the formula for every method. There’s a different way to use the functions. We are showing the procedure stepwise below to round off numbers in Excel.

• First, select the cell where we want to write the formula.
• Now, go to the Formulas tab in the ribbon and select Math & Trig.
• After that, we will see a list of functions in the drop-down. We choose the ROUND function from the list. • Consequently, the Function Argument box will appear.
• In the Number section, we select cell C5 as we want its number to round off and in Num_digits section we give the number up to which the function will keep the decimal.
• Next, press OK. • Further, use the Fill Handle to copy the formula in the following cells.
• Finally, we can see the round off prices in all cells in the range D5:D10. ## How to Round Off Negative Numbers in Excel

We can also round off negative numbers in Excel. The method is quite similar. We created a dataset which has some negative numbers. The procedure to round off negative numbers is described below stepwise.

• First, select cell C5.
• Next, write the following formula there.
`=ROUND(B5,2)`
• Then, press Enter.
• Afterwards, use the AutoFill option to copy the formula in the cells below.
• Bravo! We have successfully rounded the negative numbers in Excel. The formula used the ROUND function to round the number of cell B5 upto 2 decimals.

## Conclusion

It’s quite simple to round off numbers in Excel and we can do it using several methods. In this article we have shown 10 such easy and simple methods to round off numbers in Excel. If you have any queries or suggestions, please let us know by commenting. Please visit our ExcelDemy site for more articles about Excel.

## Related Articles #### Chinmoy Mondol

Greetings! Thank you for visiting my profile. I am Chinmoy Mondol. I am a conscientious, tech enthusiast individual with a voracious appetite for knowledge and a desire to learn more. I graduated from American International University-Bangladesh with a Bachelor's Degree in Computer Science and Engineering. I enjoy using my skills to contribute to the exciting technological advances that happen every day. Constant advancement and personal development are my guiding principles.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  