Round [ROUND]

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

Expression 1

ROUND (46.9855, 2)

Result

46.99

Expression 2

ROUND (46.9855, 0)

Result

47.00

Expression 3

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]).

  • Was this Helpful ?
  • YesNo
Relevant topics
Round to Multiple [MROUND]
Rounds the given number to the desired multiple. Syntax MROUND (Number, Multiple) Note: The required separator (comma or semi-colon) ...