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

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

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

**ROUND**function rounds up the value of cell

**C5**upto

**2**decimals.

**Read More:** **How to Add ROUND Formula to Multiple Cells in Excel (2 Easy Ways)**

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

**ROUNDUP**function takes the value of cell

**C5**and increases its decimal value by

**1**.

**Read More: ****How to Roundup a Formula Result in Excel (4 Easy Methods)**

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

**ROUNDDOWN**function to round the value of cell

**C5**upto

**1**decimal and it cuts the further decimal values.

**Read More: ****How to Round Down to Nearest Whole Number in Excel (4 Methods)**

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

**MROUND**function discards the decimal values and rounds the number by closest integer.

**Read More: ****Round to Nearest Whole Number in Excel (9 Easy Methods)**

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

**FLOOR**function here converts the value of cell

**C5**as a nearest lower value which is a multiple of value from cell

**D5**.

**Read More:** **How to Round Off to Nearest 50 Cents in Excel (4 Quick Methods)**

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

**CEILING**function rounds the value of cell

**C5**by the nearest upper multiple of value of cell

**D5**.

**Similar Readings**

**How to Stop Rounding in Excel (5 Handy Ways)****Round Down to Nearest 10 in Excel (3 Effective Ways)****How to Round Time to Nearest Minute in Excel (5 Suitable Ways)****Rounding Time to Nearest Quarter Hour in Excel (6 Easy Methods)****How to Set Rounding Precision in Excel (with Easy Steps)**

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

**INT**function gets the integer value of cell

**C5**discarding the decimal value.

**Read More:** **How to Remove Decimals in Excel with Rounding (10 Easy Methods)**

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

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

**EVEN**function takes the value of cell

**C5**and increases it to the nearest even integer.

**Read More:** **How to Round Time to Nearest 15 Minutes in Excel (6 Quick Methods)**

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

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

**ROUND**function to round the number of cell

**B5**upto

**2**decimals.

**Read More:** **How to Stop Excel from Rounding Up Decimals (4 Easy Methods)**

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