ROUND Function

The ROUND function rounds a value or the parameters resulting in a calculation to the nearest whole number. The ROUND function will round to the nearest whole positive or negative number.

Command Syntax:

ROUND([parameter1])

ROUND([parameter1]+[parameter2]+[parameter3]… )

ROUND([parameter1]-[parameter2]-[parameter3]… )

EXAMPLE:

This formula sets a value to the nearest whole number (i.e. the values 14 or -14, respectively).

ROUND(13.6)

ROUND(-13.6)