ROUNDDOWN

Round down a number to a specified number of digits.

Parameter List

Syntax
ROUNDDOWN(value
[digits]
)
value

The number to round down. For example: 1.79.

[optional] digits

The number of digits to round down. If the digit is a negative number, it rounds to the left of the decimal. For example: 2 or -2.

Examples

ROUNDDOWN(A1) returns 5Example 1