ROUND

Rounds a number to the nearest integer or to a specified number of decimal places. Use ROUND when you need to simplify results for display, ensure consistent precision, or avoid floating-point errors in financial and reporting calculations.

Syntax

ROUND(number, [decimals])

• number (Number): The value to round.

• decimals (Number, optional): The number of decimal places to keep (default = 0).

Returns: Number – The rounded result with the specified precision.

Simple Examples

ROUND(3.14159, 2)  // 3.14
ROUND(4.5)         // 5
ROUND(7.44)        // 7
ROUND(-2.6)        // -3

Business Examples

Display currency values with consistent precision

ROUND(TOTAL_PRICE, 2)

Rounds to two decimals (e.g., €45.678 → €45.68).

Standardize percentage displays in dashboards

ROUND(CONVERSION_RATE * 100, 1)

Shows a rounded one-decimal percentage.

Normalize measurement data for reports

ROUND(AVERAGE_WEIGHT, 0)

Displays whole-number results only.

Common Mistakes & Tips

• Negative decimal values round to tens, hundreds, etc. (ROUND(1234, -2) → 1200).

• Be mindful of binary floating-point rounding differences (e.g., ROUND(2.675, 2) → 2.67 in some systems).

• Use CEIL or FLOOR for directional rounding instead.

• Always round monetary calculations at the final step to minimize cumulative rounding errors.

Tests

ROUND(3.14159, 2) == 3.14    // true
ROUND(4.5) == 5              // true
ROUND(7.44) == 7             // true
ROUND(-2.6) == -3            // true
ROUND(1234, -2) == 1200      // true

See also

FLOOR · CEIL · TRUNC