round

To round a given number

You can use the function to round a decimal number to the specified number of decimal places. This is done according to the rules of commercial rounding, which means 5 or more is rounded up, 4 or less is rounded down.
If no parameter is specified for the number of decimal places, the system rounds up or down to the nearest integer with no decimal places.
Syntax
round(number)
round(number, number)
Return
number
Examples 
round(number, digits) To round a given number with the given number of digits.
​
round(number) To round a given number to the nearest integer.
1
round(2.5)
Result: 3
​
1
round(12.4987)
Result: 12
​
1
round(12.4987,2)
Result: 12.5
​
1
round(12/7,1)
Result:  1.7
See also 
​ceil, which rounds up a given number to the next higher integer.
​floor, which rounds a given number down to the nearest integer.

replacex

rpad

Last modified 1d ago