Round

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

Syntax:

Round (arg1,integer)

where arg1 is one or more of the following values:

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. 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. See Row, Column, or Cell Reference Arguments.
function	An embedded function. 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. 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. See Row, Column, or Cell Reference Arguments.

function

An embedded function.

See Mathematical Functions.

Integer specifies the number of digits to round the number:

If integer is greater than zero, the number is rounded to the specified number of decimal places.
If integer is zero, the number is rounded to the nearest integer.
If integer is less than zero, the number is rounded to the left of the decimal point.

Examples:

Round to 3 decimals:

Round(3594.5567,3)=3594.557

Round to the nearest integer:

Round(3594.5567,0)=3595

Round to the thousand, (also known as scaling):

Round(3594.5567,-3)=4000