Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.


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.

how to round off numbers in excel


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 Off Numbers Using ROUND Function

In the formula the 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.

Apply ROUNDUP Function in Excel

Here, the 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.

Number Rounding with ROUNDDOWN Function

The formula used the 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.

Excel MROUND Function to Round Off Numbers

In the formula, the 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.

Make Use of FLOOR Function in Excel

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

Insert CEILING Function for Rounding Off Numbers

Here, the CEILING function rounds the value of cell C5 by the nearest upper multiple of value of cell D5.

Similar Readings


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.

Application of INT Function in Excel

In the formula, the 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.

Excel EVEN & ODD Functions to Round Off Numbers

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.

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.

Use TRUNC Function for Rounding Numbers

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.

Apply Functions from Math & Trig Option

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

How to Round Off Negative Numbers in Excel

The formula used the 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.


Related Articles

Chinmoy Mondol

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

Leave a reply

ExcelDemy
Logo