Round
Syntax
Round(number|[|dec=dec_places])
Description
Use the Round function to round a number. Decimals and negative numbers are supported. Optionally specify the number of decimal places.
Parameters
| Parameter | Description |
|---|---|
|
number1 |
First factor. |
|
number2 |
Second factor. |
|
dec=dec_places |
(Optional) The number of decimal places. The maximum is 10. The default is zero. Note that "dec=" must be included in the parameter. |
Returns
The result of rounding number1 to dec=dec_places decimal places.
Example
The following table presents examples of using the Round function.
| Expression | Result |
|---|---|
|
Round(-130.456) |
-130 |
|
Round(-130.456|dec=2) |
-130.46 |
|
Round(-130.455|dec=2) |
-130.45 |