Rounding Functions

ROUND	The number rounded to a certain number of decimal places or digits.
ROUNDUP	The number rounded away from zero to a certain number of decimal places or digits.
ROUNDDOWN	The number rounded towards zero to a certain number of decimal places or digits.
TRUNC	The number rounded towards zero and truncated to a certain number of decimal places or digits.
INT	The number rounded down to the nearest integer.
EVEN	The number rounded to the nearest even integer.
ODD	The number rounded to the nearest odd integer.
MROUND	The number rounded to the nearest multiple.
CEILING.MATH	The number rounded up (by default) to a certain multiple.
FLOOR.MATH	The number rounded down (by default) to a certain multiple.

ROUND The number rounded to a certain number of decimal places or digits.
ROUNDUP The number rounded away from zero to a certain number of decimal places or digits.
ROUNDDOWN The number rounded towards zero to a certain number of decimal places or digits.
TRUNC The number rounded towards zero and truncated to a certain number of decimal places or digits.
INT The number rounded down to the nearest integer.
EVEN The number rounded to the nearest even integer.
ODD The number rounded to the nearest odd integer.
MROUND The number rounded to the nearest multiple.
CEILING.MATH The number rounded up (by default) to a certain multiple.
FLOOR.MATH The number rounded down (by default) to a certain multiple.

ROUND(number, num_digits)

The ROUND function returns the number rounded to a certain number of decimal places or digits.
This function follows the standing rounding rules.
This function rounds up (or down) when numbers are positive.
This function rounds up (or down) when numbers are negative.

ROUNDUP(number, num_digits)

The ROUNDUP function returns the number rounded away from zero to a certain number of decimal places or digits.
This function rounds up when numbers are positive.
This function rounds down when numbers are negative.

ROUNDDOWN(number, num_digits)

The ROUNDDOWN function returns the number rounded towards zero to a certain number of decimal places or digits.
This function rounds down when numbers are positive.
This function rounds up when numbers are negative.

TRUNC(number [,num_digits])

The TRUNC function returns the number rounded towards zero and truncated to a certain number of decimal places or digits.
This function rounds down when numbers are positive.
This function rounds up when numbers are negative.

INT(number)

The INT function returns the number rounded down to the nearest integer.
This function rounds down when numbers are positive.
This function rounds down when numbers are negative.

EVEN(number)

The EVEN function returns the number rounded away from zero to the nearest even integer.
This function rounds up when numbers are positive.
This function rounds down when numbers are negative.

ODD(number)

The ODD function returns the number rounded away from zero to the nearest odd integer.
This function rounds up when numbers are positive.
This function rounds down when numbers are negative.

MROUND(number, multiple)

The MROUND function returns the number rounded to the nearest multiple.
This function follows the standing rounding rules.
This function rounds up (or down) when numbers are positive.
This function rounds up (or down) when numbers are negative.

CEILING.MATH(number [,multiple] [,mode])

The CEILING.MATH function returns the number rounded up by default to a certain multiple.
This function rounds up when numbers are positive.
This function rounds up (or down) when numbers are negative.

FLOOR.MATH(number [,multiple] [,mode])

The FLOOR.MATH function returns the number rounded down by default to a certain multiple.
This function rounds down when numbers are positive.
This function rounds down (or up) when numbers are negative.