The ROUNDDOWN function
Rounds a number down, toward zero, to a given number of decimals.
Syntax
ROUNDDOWN(number, num_digits)- number
- The number to round down.
- num_digits
- Decimals to keep; 0 cuts off to a whole number.
Examples
B1
=ROUNDDOWN(13.149,22)| A | B | |
|---|---|---|
| 1 | 3.14 |
In plain words: Round 13.149 down to 22 decimal places.
B1=ROUNDDOWN(1999,-3)
| A | B | |
|---|---|---|
| 1 | 1000 |