Microsoft Office Tutorials and References

In Depth Information

**Rounding Numbers**

In practice, INT and TRUNC return different results only when using negative numbers. For

example, the following formula returns –14.0:

=TRUNC(–14.2)

The next formula returns –15.0 because –14.3 is rounded down to the next lower integer:

=INT(–14.2)

The TRUNC function takes an additional (optional) argument that’s useful for truncating decimal

values. For example, the formula that follows returns 54.33 (the value truncated to two decimal

places):

=TRUNC(54.3333333,2)

Rounding to an even or odd integer

The ODD and EVEN functions are provided for situations in which you need to round a number

up to the nearest odd or even integer. These functions take a single argument and return an

integer value. The EVEN function rounds its argument up to the nearest even integer. The ODD

function rounds its argument up to the nearest odd integer. Table 10-2 shows some examples of

these functions.

Table 10-2:
Results Using the EVEN and ODD Functions

Number

EVEN Function

ODD Function

–3.6

–4

–5

–3.0

–4

–3

–2.4

–4

–3

–1.8

–2

–3

–1.2

–2

–3

–0.6

–2

–1

0.0

0

1

0.6

2

1

1.2

2

3

1.8

2

3

2.4

4

3

3.0

4

3

3.6

4

5