ROUNDUP
Rounds a number away from zero to the specified number of digits.
Syntax
=ROUNDUP(number, num_digits)
Example:
=ROUNDUP(125.671,2)
Result: 125.68
ROUNDDOWN
Rounds a number toward zero to the specified number of digits.
Syntax
=ROUNDDOWN(number, num_digits)
Example:
=ROUNDDOWN(125.679,2)
Result: 125.67
Comparison
|
Function |
Example |
Result |
|
ROUND |
125.675, 2 |
125.68 |
|
ROUNDUP |
125.671, 2 |
125.68 |
|
ROUNDDOWN |
125.679, 2 |
125.67 |
Practice
Create 10 decimal values and calculate all three:
- ROUND
- ROUNDUP
- ROUNDDOWN