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 the nearest multiple.
CEILING.MATH	Returns the number rounded to the nearest multiple.
FLOOR.MATH	Returns the number rounded to the nearest 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 the nearest multiple.
CEILING.MATH Returns the number rounded to the nearest multiple.
FLOOR.MATH Returns the number rounded to the nearest 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 when digits are greater than or equal to 5.
This function rounds down when digits are less than 5.

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 rounds up when numbers are positive.
This function can round up (or down) when numbers are negative.
If an exact multiple, there will be no rounding.

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

The CEILING.MATH function returns the number rounded to the nearest multiple.
This function rounds up when numbers are positive.
This function can round up (or down) when numbers are negative.
If an exact multiple, there will be no rounding.

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

The FLOOR.MATH function returns the number rounded to the nearest multiple.
This function rounds down when numbers are positive.
This function can round down (or up) when numbers are negative.
If an exact multiple, there will be no rounding.