ROUNDUP Function

The ROUNDUP function acts similarly to the ROUND function, except that it always rounds up (away from zero (0)).

Command Syntax:

ROUNDUP([parameter1])

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

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

EXAMPLE:

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

ROUNDUP(13.1)

ROUNDUP(-13.1)