ROUNDDOWN
Rounds a number down, toward zero.
Math & TrigonometryMath BasicsMost Used
What it does
Rounds a number down (toward zero) to a specified number of digits.
Syntax
ROUNDDOWN(number, num_digits)
Arguments
number(number) — Number to round.
Examples
Round down to 0 decimals
Round A2 down to a whole number.
FORMULA
=ROUNDDOWN(A2,0)
RESULT
3
SAMPLE DATA
| A | |
|---|---|
| 1 | Number |
| 2 | 3.99 |
| 3 | 2.01 |