ROUND function

Synopsis

This function returns the nearest whole number from the specified value. If the value is midway between 2 whole numbers, it is rounded toward the nearest whole number that is furthest away from zero.

Variations

ROUND (Number)

Returns the nearest whole number from the specified value.

Details | Examples | Details and examples

Parameters

Number

Specifies the number to round.

Supported types: Numeric.

Returns

Returned types: Numeric.

Examples

1.	The following example returns 2. ROUND(2.4)
2.	The following example returns 3. ROUND(2.5)
3.	The following example returns 3. ROUND(2.6)
4.	The following example returns -2. ROUND(-2.4)
5.	The following example returns -3. ROUND(-2.5)
6.	The following example returns -3. ROUND(-2.6)