ROUNDDOWN
Rounds a number down (to a lesser value) to the specified number of digits.
Syntax
=ROUNDDOWN(value, digits)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | The value to round |
| digits | Number | (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
Updated 10 months ago