Microsoft Office Tutorials and References

In Depth Information

**Leaving All Decimals Behind with INT**

Example of

Function

Result

Comment

=EVEN(-3.5)

–4

Rounds to the next even integer, moving away

from 0.

=ODD(3)

3

Because 3 is an odd number, no rounding takes

place. The number 3 itself is returned.

=ODD(4)

5

Rounds to the next odd integer, moving away

from 0.

=ODD(5.01)

7

Rounds to the next odd integer, moving away

from 0.

=ODD(-3.5)

–5

Rounds to the next odd integer, moving away

from 0.

The EVEN function is helpful in calculations that depend on multiples of two.

For example, let’s say you’re in charge of planning a school trip. You need to

figure out how many bus seats are needed for each class. A seat can fit two

children. When a class has an odd number of children, you still have to count

that last seat as taken, even though only one child will sit there.

Say the class has 17 children. This formula tells you how many seats are

needed: =EVEN(17)/2. The EVEN function returns the number 18 (the next

higher integer), and that result is divided by 2 because two children fit on

each seat. The answer is 9 seats are needed for a class of 17.

Here’s how to use either the EVEN or ODD function:

1. Position the cursor in the cell where you want the results to appear.

2. Enter either
=EVEN(
or
=ODD(
to begin the function entry.

3. Click a cell where you entered a number, or enter a number.

4. Type a
), and press the Enter key.

Leaving All Decimals Behind with INT

The INT function rounds a number down to the next lowest integer. The

effect is as if the decimal portion is just dropped, and often INT is used to

facilitate just that — dropping the decimal.