@ROUND

@ROUND(x;n) rounds the value x to the nearest multiple of the power of 10 specified by n.



Arguments

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.



Notes

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.



Examples

@ROUND(134.578;2) = 134.58

@ROUND(134.578;0) = 135

@ROUND(134.578;-2) = 100



See also
More power with @functions
@functions A-Z