Returns the specified number, rounded down (towards zero) to the specified number of digits.
Syntax Copy Code |
---|
ROUNDDOWN( Number n, [Integer digits = 0] ) → Number |
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.
Formula Copy Code |
---|
=ROUNDDOWN(2.95,1) |
Function Reference
TRUNC Function
INT Function
ROUND Function
ROUNDUP Function