Round
Round is a mathematical function that rounds a number up or down by the specified digits. The function syntax:
Round (arg1, integer)
where arg1 is one or more of these arguments:
Argument | Description |
---|---|
numeric |
A numeric value. For example, Round(81.3987,3) returns the value 81.399. Numeric values can include decimals and negative values. |
row, column, or cell reference |
A pointer to a row, column, or cell within a grid. References can be specified in several ways. The reference syntax: |
function |
An embedded function |
Integer specifies the number of digits to which you want to round the number:
-
If integer is greater than zero, the number rounds to the specified number of decimal places.
-
If integer is zero, the number rounds to the nearest integer.
-
If integer is less than zero, the number is rounded to the left of the decimal point.
Examples:
The following example rounds to three decimals:
Round(3594.5567,3) = 3594.557
The following example rounds to the nearest integer:
Round(3594.5567,0) = 3595
The following example rounds to the thousands. This is also known as scaling:
Round(3594.5567,-3) = 4000