What is ROUNDDOWN?
Always rounds a number down, toward zero. Useful for truncating to specific decimal places conservatively.
Syntax
=ROUNDDOWN(number, num_digits)
Example
Formula: =ROUNDDOWN(A1, 0)
Result: 3
How It Works
Always rounds down to the lower value. If A1 is 3.99, ROUNDDOWN(A1, 0) returns 3. Always truncates toward zero.