It returns numbers 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 this small article, you’ll learn how to utilize the ROUND () function in MS Excel with syntax and some examples. Let’s walk through…
Syntax of the ROUND function
= ROUND (number, num_digits)
Where
- numberrepresents the number that you wish to round and
- num_digitsrepresent 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:
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 auto fill 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 a number round up to one decimal place, and the formula = ROUNDUP (D6,1). Please check out the screenshot.
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 a number rounded down to the nearest integer, and the formula = ROUNDDOWN (D6, 1). Please check out the screenshot.
EVEN Function
The EEVEN function round a given number to the nearest even number. Select a cell and type this formula = EVEN (A2) into it, and press Enter key; then you need to apply this formula to other cells; you can drag the autofill handle to fill them.
For example, for a given number 10, the EVEN function returns the result as ten which is number round to the nearest even number, and the formula = EVEN (D6). Check out the screenshot below:
Excel Odd Function
The ODD function rounds the number to the 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.
ROUND function
The ROUND 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 CEILING 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 a number rounded down to the nearest multiple of 3, and the formula = FLOOR (D6, 3)
Here it ends!