Rounds a number to a specified number of digits.
Syntax
ROUND (Number, NumberOfDigits)
Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.
Data Types of the Arguments
Number: Integer, Number
Number of Digits: Integer
If the Number of Digits argument is positive, rounding takes place to the specified number of decimal places. See Expression 1 below.
If the Number of Digits argument is zero, the number is rounded to the nearest integer. See Expression 2 below.
If the Number of Digits argument is negative, rounding takes place only to the left of the decimal point (decimal values are disregarded). See Expression 3 below.
Data Type of the Result
Number
The number of decimal places displayed in the result depends on Preferences > Working Units.
Examples
ROUND (46.9855, 2)
Result
46.99
ROUND (46.9855, 0)
Result
47.00
ROUND (46.9855, -1)
Result
50.00
Notes
To always round up, use Round Up [ROUNDUP]. To always round down, use Round Down [ROUNDDOWN].
To round to a certain multiple, use Round to Multiple [MROUND] (or Round Up to Multiple [MROUNDUP] or Round Down to Multiple [MROUNDDOWN]).