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.
Search JabSto ::




Custom Search