ROUNDP
Returns a value representing a number rounded to the nearest of a specified number of
digits.
Syntax
ROUNDP(Value, Decimals)
Value
is the number to be rounded.
Decimals
is the number of decimals to which the number
should be rounded. If Decimals
is negative, then the
number is rounded to digits to the left of the decimal separator.
Examples
This example returns 1.2:
ROUNDP(1.234, 1)
This example returns 2040:
ROUNDP(2035, -1)
This example returns 1.24:
ROUNDP(1.235, 2)