SharpCloud: Function ROUND()

Rounds a number to the nearest integer; values .5 or higher round up, below .5 round down.

Title

Answer

Function ROUND()

Description
Rounds a number to the nearest integer; values ≥ .5 round up, values < .5 round down.

Syntax

ROUND(value)

Parameters

Return Value
NUMBER

Examples

Formula

ROUND(5.4)

Result
5

Formula

ROUND(5.5)

Result
6

Notes

URL Name

SharpCloud-Function-ROUND

SharpCloud: Function ROUND()

Related Articles