These functions control decimal values.
ROUND
Syntax
=ROUND(number,num_digits)
Example:
=ROUND(125.678,2)
Result:
125.68
ROUNDUP
Always rounds away from zero.
=ROUNDUP(125.671,2)
Result:
125.68
ROUNDDOWN
Always rounds toward zero.
=ROUNDDOWN(125.679,2)
Result:
125.67
INT
Returns the integer portion by rounding down to the nearest integer.
=INT(125.99)
Result:
125
TRUNC
Removes decimal digits without rounding.
=TRUNC(125.99)
Result:
125
Practical Example
|
Original Value |
ROUND |
ROUNDUP |
ROUNDDOWN |
INT |
TRUNC |
|
125.678 |
|||||
|
89.456 |
|||||
|
42.999 |
Practice
Create an Invoice Rounding Sheet and apply different rounding methods to prices and tax amounts.