Rounds the designated number to the nearest whole number; if an additional number is specified, it is used as the rounding factor.
@Round( number ) @Round( number ; factor )
number
Number or number list. Numbers to be rounded.
factor
Number. Optional. The rounding factor to use. For example, if factor is 10, @Round rounds to the nearest number that is a factor of 10. If you don't specify a factor, the number is rounded to the nearest whole number.
roundedNumber
Number. The value of number, rounded to the specified factor or to the nearest whole number. If number is a list, each number in the list is rounded to the specified factor or to the nearest whole number.
When using this function with a number list, the list concatenation operator takes precedence over any other operators.
For more information, see "List concatenation operator."
@Round(2.499)
@Round(2.5)
@Round(1.5)
@Round(NumberOfEmployees;10)
@Round(1.333:2.897654:3.1:4)
@Round(4505:45005:450005;10)
@Round(3.142857; 0.001)