Returns the specified number, rounded down (towards zero) to the specified number of digits.

Syntax  Copy Code
ROUNDDOWN( Number n, [Integer digits = 0] ) → Number

Parameters

n

Required. The number to round.

digits

Optional. The number of digits to round to. If omitted, digits is assumed to be 0.

Remarks

If digits is greater than 0, the number is rounded to the specified number of decimal places. If digits is 0, the number is rounded down to the nearest integer. If digits is less than 0, the number is rounded to the left of the decimal point. If digits is not integer, it is automatically truncated.

Example

Formula  Copy Code
=ROUNDDOWN(2.95,1) =ROUNDDOWN(21.9,-1)

See Also

Function Reference
TRUNC Function
INT Function
ROUND Function
ROUNDUP Function