Policies & Guidelines

ROUND

Round a number

Description

Returns the given number rounded to the nearest integer.

Function signature

ROUND(number: Number, precision: Number) => Number

Parameter

Description

Number

Number to round

Precision

The number of digits to appear after the decimal point. If precision is negative, rounds to tens/hundreds/thousands

Examples

Formula

Return value

ROUND(294.45, 1)

294.5

ROUND(294.45, 0)

294

ROUND(294.45)

294

ROUND(294.45, -1)

290

ROUND(1894.451, -3)

2000