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)