ROUNDDOWN

Rounds a number down (to a lesser value) to the specified number of digits.

Syntax

=ROUNDDOWN(value, digits)

Arguments

Argument	Type	Description
value	Number	The value to round
digits	Number	(Optional) The number of digits to round the value, defaults to 0

Examples

=ROUNDDOWN(2.5)→2
Rounds the value 2.5 to 1 digit

=ROUNDDOWN(-3.14159, 2)→-3.15
Rounds the value 3.14159 to 2 digits

=ROUNDDOWN(8192, -2)→8100
Rounds the value -8192 to 2 digits