ROUND

The ROUND function rounds a number to the specified number of decimal places.

Syntax

round(value, significance)

Arguments

value - Required. The number to be rounded.

significance - Optional. The decimal places to which the number should be rounded. If this argument is missing, it is considered as 1.

Example

round(COLUMN1, 2)

Returns the round of COLUMN1 to the significance of two decimals

Excel equivalent

ROUND