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: GridName.GridElement[segment(range)].property |
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