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. 
The function only rounds visually for the display of the respective value. Internally, the number in question is retained with all decimal places and is also used for calculations. It can therefore be useful to additionally use this function in formulas.
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 7mo ago