@ROUNDDOWN

Rounds down a number to a specified number of digits. For example, if cell A.1 contains 2.199, and you want to round that value down to one decimal place, you can use the following formula: 
@ROUNDDOWN(A.1, 1). The result of this function is 2.1.

Syntax

@ROUNDDOWN(V1, V2)

Argument	Description
V1	Required. The number you want to round down.
V2	Required. The number of digits to which you want to round down the number argument.

Notes

• The function tries to round a number towards zero; after rounding, a positive number would become less positive, while a negative number would become less negative.
• If the number of digits is positive, the number is rounded down to the specified number of decimal places.
• If the number of digits is zero, the number is rounded down to the nearest integer.
• If the number of digits is negative, the number is rounded down to the left of the decimal point.

Examples

@ROUNDDOWN(3.2, 0) = 3

@ROUNDDOWN(76.9, 0) = 76

@ROUNDDOWN(3.14159, 3)= 3.141

@ROUNDDOWN(-3.14159, 1) = -3.1

@ROUNDDOWN(3.1415.9264, -2) = 31400

@ROUNDDOWN(1.98, -1) = 0

@ROUNDDOWN(-50.55, -1) = 50

@ROUNDDOWN(-49.99. -1) = -40