ROUND

Rounds a number to a specified number of fractional digits, and rounds midpoint values to the nearest even number.

Usage

ROUND(number1, number2)

Parameters

number1

Number

Number to be rounded.

number2

Number

Number of fractional digits in the return value.

Returns

Number

Examples

ROUND(1.6278, 2)

1.63

ROUND(1.6278, 0)

2

Remarks

The value of the digits argument can range from 0 to 15. The function will fail if a number outside of that range is provided.