ROUNDDOWN function

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


ROUNDDOWN (number, count)

Returns number rounded down (towards zero) tocount 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.


=ROUNDDOWN(1.234,2) returns1.23.

=ROUNDDOWN(45.67,0) returns 45.

=ROUNDDOWN(-45.67) returns -45.

=ROUNDDOWN(987.65,-2) returns 900.

Trademarks | IBM Connections wiki