These docs are for v1.0. Click to read the latest docs for v1.2.

ROUNDDOWN

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

Syntax

=ROUNDDOWN(value, digits)

Arguments

ArgumentTypeDescription
valueNumberThe value to round
digitsNumber(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