ROUND
Round a number

Description

Returns the given number rounded to the nearest integer.

Function signature

1
ROUND(number: Number, precision: Number) => Number
Copied!
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
Last modified 1yr ago
Export as PDF
Copy link