ROUND

Rounds the number passed to the function to specified number of digits.

Syntax

= ROUND(value, numberOfDigits)

Parameters

Value

A number which is to be rounded.  The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice).

numberOfDigits

The number of places to which the number is to be rounded. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice).

Return Type

Decimal number.

In the case of an error, the function displays an error message: “ROUND(number, numberOfDigits): Error message”

The function can be used in combination with other functions.

Examples

Example

Returns

= ROUND(-3.75, 1)

-3.8

= ROUND(3.75, 0)

4

= ROUND(“$3.74”, 1)

3.7

= ROUND(UnitPrice, 1)

The rounded value of UnitPrice upto 1 decimal place.

= ROUND(“abcd”, “efg”)

Displays message “ROUND(abcd, efg): Input string was not in a correct format.”

= POWER(ROUND(UnitPrice), 2)

The square of the round value of UnitPrice

= MAX(ROUND(UnitPrice), 12)

The maximum among the round value of UnitPrice and the number 12.