Microsoft Office Tutorials and References
In Depth Information
Using ROUND, ROUNDDOWN, ROUNDUP, INT, TRUNC, FLOOR, FLOOR.MATH, CEILING, CEILING.MATH, EVEN, ODD, or MROUND to Remove Decimals or Round Numbers
ROUND ,, ROUNDDOWN
ROUNDDOWN ,, ROUNDUP
ROUNDUP ,, INT
INT ,, TRUNC
TRUNC ,, FLOOR
FLOOR ,, FLOOR.MATH
CEILING ,, CEILING.MATH
CEILING.MATH ,, EVEN
EVEN ,, ODD
ODD ,, oor MROUND
MROUND tto Remove
You can use a variety of functions — including ROUND, ROUNDDOWN,
ROUNDUP, INT, TRUNC, FLOOR, FLOOR.MATH, CEILING, CEILING.MATH,
EVEN, ODD, and MROUND — to round a result or to remove decimals from a
The TRUNC, INT, EVEN, and ODD functions always change a number to an in-
teger. The syntax in each case is similar: The function accepts a single num-
ber or a single cell containing a number.
To remove the decimals from a result, use the =TRUNC function. This trun-
cates a number to the integer portion of the number. For example, =TRUNC(1.9)
is 1, and =TRUNC( – 1.9) is – 1.
To remove the decimals from a result and always round down to the next low-
est integer, use =INT. For positive numbers, TRUNC and INT return identical
values. A subtle difference exists between TRUNC and INT. When you have a
negative number, INT rounds away from zero to produce the next lowest in-
teger. Thus, =INT( – 1.1) is – 2.
EVEN rounds a number away from zero to the next even integer. For example,
=EVEN(3) is 4, and =EVEN(-3) is – 4. If the number is already an even integer,
no adjustment is made; for example, =EVEN(6) is 6. This function is ideal for
ordering products packed two to a case.
ODD rounds a number away from zero to the next odd integer. For example,
=ODD(1.1) is 3, and =ODD(-3.1) is – 5. If the number is already an odd integer,
no adjustment is made.
Figure 11.7 compares the results of TRUNC, INT, EVEN, and ODD.