ROUND(


General Form:

     ROUND(numeric_expression1, numeric_expression2)


The ROUND( function rounds a numeric expression to a specified decimal or integer position. The first argument is the expression which is to be rounded, the second specifies the rounding factor.

A positive rounding factor rounds the value to the specified position after the decimal point. A negative rounding factor rounds the integer to a specified position to the left of the decimal point.

Syntax examples:

New = ROUND(1234.56789,2)
First = ROUND(1234.56789,-2) * Second