ROUND

Round a number up or down to a specified number of digits.

Parameter List

Syntax
ROUND(value
[digits]
)
value

The number to round. For example: 1.78.

[optional] digits

The number of digits to round. If the digit is a negative number, it rounds to the left of the decimal. For example: 2 or -2.

Examples

ROUND(A1) returns 6Example 1