Expressions Guide - ROUND (Functions)

ROUND

The ROUND function is a mathematical function that returns a number rounded to a specified number of decimal places.

The ROUND function performs round to even rather than round to larger. This means that the function returns the number closest to the value of the expression. If the expression value is exactly halfway between two rounded values, the function returns the value that has an even last digit (the digit on the far right).

Function Name	ROUND
Description	Returns a number rounded to a specified number of decimal places.
Arguments	ROUND(INPUT NUMBER, DECIMAL PLACES) Where: INPUT NUMBER is an INTEGER or REAL and is the numerical expression that is to be rounded. DECIMAL PLACES is also a numerical expression (INTEGER or REAL) and specifies the number of decimal places to return. For more information on integers and real values, see Number (Integer or Real).
Returns	REAL. The input number rounded to a specified number of decimal places.

Example:

ROUND(1.27489, 2)

The output is 1.27

ROUND(1.4453,1)

The output is 1.4

ROUND(1.5, 0)

The output is 2.

ROUND(2.5, 0)

The output is 2.

ROUND(3.5, 0)

The output is 4.