ROUND

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 required 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 round.

• significance (Optional): The number of decimal places to which the value should be rounded. If not specified, the default value is 1.

Return value

Returns the rounded value with the specified precision.

Example

ROUND(Total Sales, 2)

In the example below, the Rounded Sales measure is created using the ROUND function, which rounds the values in Total Sales to 2 decimal places.

Excel equivalent

ROUND