@ROUND(x;n) rounds the value x to the nearest multiple of the power of 10 specified by n.
x is a value.
If n is ... | @ROUND ... |
Positive | Affects the decimal portion of the number (moving right from the decimal point). For example, if n is 2, x is rounded to the nearest hundredth. |
Negative | Affects the integer portion of the number (moving left from the decimal point). For example, if n is -2, x is rounded to the nearest hundred. |
0 | Rounds to the nearest integer. |
Use the Fixed format to display values with a specified number of decimal places. If you want your spreadsheet to calculate the values to their full precision, do not use @ROUND.
@ROUND(134.578;2) = 134.58
@ROUND(134.578;0) = 135
@ROUND(134.578;-2) = 100