Introduction

It returns number rounded to a certain number of digits in your spreadsheet. The ROUND function can round to the left or right of the decimal point. This function applies to MS Excel 2007 and all higher versions.

In that small article, you'll learn how to utilize the ROUND() function in MS Excel with syntax and some examples. Let's walkthrough...

Syntax of ROUND function

=ROUND(number, num_digits

Where

  • number represents  the number that you wish to round and
  • num_digits represent the number of digits to which you want to round the number argument.

Excel ROUND Function

You can see the list of numbers in column C and their round values. Please check out the example below:

Round() Function in Excel 1

In this case,

  • The formula=ROUND(C4,1) for number 10.567 (C4)  results to round value to 1 decimal place 10.6
  • The formula= ROUND(C4,2 ) for number 10.567 (C4)  results to round value to 2 decimal place 10.57
  • The formula= ROUND(C4,-1 ) for number 10.567 (C4)  results to round value nearest to 10 is 10.
  • The formula= ROUND(C4,-2 ) for number 10.567 (C4)  results to round value nearest to 100 is 0.

Then if you need to apply this formula to other numbers in column C, you can drag the autofill handle to fill them. Excel will automatically fill up them saving your time and effort.

 Please try these!



Round() Function in Excel

The ROUNDUP() function always rounds a number up (away from zero). For example, for a given number 123.4567, the ROUNDUP function returns the result as 123.5 which is number round up to one decimal place and the formula = ROUNDUP (D6,1). Please check out the screenshot.

Round() Function in Excel 2


ROUNDDOWN Function

The ROUNDDOWN function always rounds a number down (toward zero). For example, for a given number 123.4567, the ROUNDDOWN function returns the result as 123 which is number round down to the nearest integer and the formula =ROUNDDOWN (D6,1). Please check out the screenshot.

Round() Function in Excel 3


EVEN function

The EEVEN function round a given number to nearest even number. Select a cell and type this formula =EVEN(A2) into it, and press Enter key, then if you need to apply this formula to other cells, you can drag the auto fill handle to fill them. See screenshot:

For example, for a given number 10, the EVEN function returns the result as 10 which is number round to the nearest even number and the formula =EVEN (D6). Check out the screenshot below:

Round() Function in Excel 4


Excel Odd Function

The ODD function rounds number to nearest odd number. For example, for a given number 10, the ODD function returns the result as 11 which is number round to the nearest odd number and the formula =ODD (D6)

Note that the ODD function always rounds up to the next odd integer.

MROUND function

The MROUND function in MS Excel returns a number rounded to a given multiple. For example, for a given number 10, the MROUND function returns the result as 9 which is round to the nearest multiple of 3 and the formula =MROUND(D6,3).


CEILING Function In Round() Function in Excel

The Excel CELING function returns a given number rounded up to a specified multiple. For example, for a given number 10, the CEILING function returns the result as 12 which is round up to the nearest multiple of 3 and the formula =CEILING(D6,3)


FLOOR Function

The Excel FLOOR function rounds a given number down to the nearest specified multiple.For example, for a given number 10, the FLOOR function returns the result as 9 which is number round down to the nearest multiple of 3 and the formula =FLOOR (D6,3)

Conclusion

That’s done!!!