ROUND
Rounds a number to a defined number of digits.
Syntax
ROUND(number; digits; direction)
number - the number which should be rounded - Value Type: number
digits - the number of digits which should be rounded - Value type: number (optional, default value: 0)
direction - defines if the number should be rounded to the nearest integer, up or downwards - Value type: constant (optional, default value: nearest) Possible values are:
nearest - value is rounded to the nearest number defined by digits. Here numbers with fraction part “5” are rounded “away from zero”.
up - value is rounded up (away from zero)
down - value is rounded down (towards zero)
Remarks
If digits is a negative value, the nearest number is left of the decimal point.
The parameter direction can only be defined if parameter digits is defined as well.
