ROUNDDOWN function

ROUNDDOWN rounds a number down, toward zero, to a certain precision. See ROUNDUP and ROUND for alternatives.

Syntax

ROUNDDOWN (number, count)

Returns number rounded down (towards zero) to count decimal places. If Count is omitted or zero, the function rounds down to an integer. If count is negative, the function rounds down to the next 10, 100, 1000, and so on.

Example

=ROUNDDOWN(1.234,2) returns1.23.

=ROUNDDOWN(45.67,0) returns 45.

=ROUNDDOWN(-45.67) returns -45.

=ROUNDDOWN(987.65,-2) returns 900.