Round

Round is a mathematical function that rounds a number up or down by the specified digits. The function syntax is:

Round (arg1, integer)

where arg1 is expressed by one or more of the following 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. For a description of numeric arguments, see Numeric Arguments.
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 is: GridName.GridElement[segment(range)].property For more information, see Row, Column, or Cell Reference Arguments.
function	An embedded function. For a list of mathematical functions, see Mathematical Functions.

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. For a description of numeric arguments, see Numeric Arguments.

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

For more information, see Row, Column, or Cell Reference Arguments.

function

An embedded function. For a list of mathematical functions, see Mathematical Functions.

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 3 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