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**

Using

Using
ROUND

ROUND
,,
ROUNDDOWN

ROUNDDOWN
,,
ROUNDUP

ROUNDUP
,,
INT

INT
,,
TRUNC

TRUNC
,,
FLOOR

FLOOR
,,
FLOOR.MATH

FLOOR.MATH
,,

CEILING

CEILING
,,
CEILING.MATH

CEILING.MATH
,,
EVEN

EVEN
,,
ODD

ODD
,, oor
MROUND

MROUND
tto Remove

Remove Decimals

Decimals oor

Round Numbers

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

result.

Syntax

=TRUNC(number)

=INT(number)

=EVEN(number)

=ODD(number)

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.