<< Click to Display Table of Contents >> ROUNDDOWN (round down to n digits)

Syntax:

ROUNDDOWN(Number, n)

Description:

This rounds a number down (towards zero) to n decimal places.

n is the desired number of decimal places.

If n is omitted, Number is rounded down to the nearest integer.

If n is a negative value, Number is rounded down to the left of the decimal point. For example, if n is -2, Number is rounded to the nearest multiple of a hundred (see second last example).

Note:

Negative numbers are rounded up rather than rounded down (see last example). This is not mathematically correct, but it is implemented exactly as in Microsoft Excel for compatibility reasons.

Example:

ROUNDDOWN(1.234, 2) returns 1.23

ROUNDDOWN(1.235, 2) returns 1.23

ROUNDDOWN(888.999, 0) returns 888

ROUNDDOWN(888.999, -2) returns 800

ROUNDDOWN(-7.8, 0) returns -7

See also:

ROUNDUP, ROUND, MROUND, TRUNC, FIXED, INT, EVEN, ODD, CEILING, FLOOR