← Back to level 1
Level 1Next
ROUNDDOWN
A easy rounding formula that always moves a value downward to the precision you choose.
Syntax
=ROUNDDOWN(...)Step-by-step explanation
- 1Select the numeric value or range that needs to be adjusted.
- 2Choose the rounding or comparison function that matches the outcome you want.
- 3Press Enter and compare the returned value with the original number.
Common mistakes
Expecting normal rounding behavior
Using it with negative values without checking the result
Choosing the wrong digit count
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=ROUNDDOWN(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =ROUNDDOWN(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use ROUNDDOWN when you want a conservative result and should not round up.
Match against the syntax block above.