RND

 

RND rounds a number to the nearest value of a specified number of decimal places.

 

RND(<number>, <dec places>)

 

RND(12.5, 0) equals 13

RND(12.34, 1) equals 12.3

 

A negative value for the number of decimal places rounds the number to e.g. the nearest 10, 100, etc.

 

RND(123.4, -1) equals 120