The ROUND function in Excel rounds values to the specified number of digits, i.e. characters before or after the decimal point. For example, using it, you can round the numbers in cell A2 from two decimal places to one:
The ROUND function in Excel always rounds away from zero (modulo). The following example demonstrates this feature:
ROUND Function Syntax
ОКРУГЛ(число; число_разрядов)
ROUND(number, num_digits)
Arguments for the ROUND function can be numbers, text representations of numbers, cell references with numeric data, as well as formulas and functions. Both arguments are required.
Number (number) – value to be rounded.
Number_digits (num_digits) – the number of digits to which the argument must be rounded number (number).
- Argument
number_digits
- (num_digits) could be:
- Positive – the fractional part of the original value (to the right of the decimal point) is rounded.
- Equal to zero – the value is rounded to the nearest integer.
- Negative – the integer part of the original value (to the left of the decimal point) is rounded.
If as an argument number_digits (num_digits) substitute a non-integer number, Excel will discard the fractional part when calculating.
Helpful information
- Excel has other useful functions for rounding. Here is some of them:
- ROUND – rounds to the nearest multiple.
- ROUNDDOWN and ROUNDUP – round up or down.
- INTEGER – rounds up to a whole number.
- OTBR – discards the fractional part.
- EVEN and ODD – round to the nearest integer: even or odd.
Examples of using the ROUND function in Excel
- The following example shows the operation of the ROUND function with a negative, positive, and zero second argument.
- This example uses another Excel function as the first argument. The formula first sums the values in the range A2:A4 and then rounds the result to one decimal place.
- The ROUND function can be used in Excel and in array formulas. For example, the following formula first rounds the values in the range A2:A4 to two decimal places, then sums them up and returns the result.