ROUNDDOWN Function

The ROUNDDOWN function acts similarly to the ROUND function, except that it always rounds down (toward zero (0)).

Command Syntax:

ROUNDDOWN ([parameter1])

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

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

EXAMPLE:

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

ROUNDDOWN (13.1)

ROUNDDOWN (-13.1)