Rounding Functions

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

ROUND Returns the number rounded to a certain number of decimal places or digits.
ROUNDUP Returns the number rounded away from zero to a certain number of decimal places or digits.
ROUNDDOWN Returns the number rounded towards zero to a certain number of decimal places or digits.
TRUNC Returns the number rounded towards zero and truncated to a certain number of decimal places or digits.
INT Returns the number rounded down to the nearest integer.
EVEN Returns the number rounded to the nearest even integer.
ODD Returns the number rounded to the nearest odd integer.
MROUND Returns the number rounded to a certain multiple.
CEILING.MATH Returns the number rounded up by default to a certain multiple.
FLOOR.MATH Returns 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 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 a certain multiple.
This function rounds up 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.