ROUND

Rounds a number to a specified number of decimal places to ensure consistent precision in calculations.

The ROUND function rounds a number to a specified number of decimal places. It adjusts the value based on standard rounding rules to produce a result with the desired precision. This function is commonly used in financial calculations, reporting, and data formatting where consistent decimal accuracy is required.

Syntax

ROUND(value, significance)

Arguments

value - The number to be rounded (Required).

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

Example

ROUND(COLUMN1, 1)

In the example below, the ROUND measure is created using the ROUND function, which rounds the values in MEASURE 2 to the specified number of decimal places.

Applying ROUND Function

Excel equivalent

ROUND