ROUNDDOWN

Description Rounds a number down.

Syntax ROUNDDOWN ( number, number_of_digits)

Argument Description

number Any real number you want to round.

number_of_digits The number of decimal places to which number is rounded. When a negative precision is used, the digits to the right of the decimal point are dropped and the absolute number of significant digits specified by precision are replaced with zeros. If precision is 0, number is rounded down to the nearest integer.

Argument	Description
number	Any real number you want to round.
number_of_digits	The number of decimal places to which number is rounded. When a negative precision is used, the digits to the right of the decimal point are dropped and the absolute number of significant digits specified by precision are replaced with zeros. If precision is 0, number is rounded down to the nearest integer.

Example This function returns 31.141:

ROUNDDOWN(3.14159, 3)

This function returns 31.400:

ROUNDDOWN(31415.92654, -2)

See Also CEILING, FLOOR, INT, MOD, ROUND, ROUNDUP, TRUNC