Microsoft Office Tutorials and References
In Depth Information
CEILING does the opposite. It increases a positive number away from 0 and
also increases a negative number away from 0, which in absolute terms
means the number is getting smaller.
For both the FLOOR and CEILING functions, the first and second arguments
must match signs. Trying to apply a positive number with a negative multiple,
or vice versa, results in an error.
Here’s how to use either the FLOOR or CEILING function:
1. Enter a number in any cell.
2. Position the cursor in the cell where you want the results to appear.
3. Enter either =FLOOR( or =CEILING( to begin the function entry.
4. Click the cell where you entered the number.
5. Enter a comma ( ,).
6.Enteranumberthatisthenextmultipleyouwanttoroundthe
number to.
For example, to get the floor value, at the ones place, make sure 1 is the
second argument. The first argument should, of course, be a number
larger than 1, and should be a decimal value, like this: =Floor(19.77, 1).
This returns 19 as the floor, but hey — don’t hit the ceiling about it!
7. Type a ), and press the Enter key.
Rounding to the next even or odd number
The EVEN and ODD functions round numbers away from 0. The EVEN
function will round a number to the next highest even integer. ODD rounds a
number to the next highest odd integer. Table 7-4 has examples of how these
functions work.
Table 7-4
Rounding to Even or Odd Integers
Example of
Function
Result
Comment
4
Rounds to the next even integer, moving away
from 0.
=EVEN(3)
=EVEN(4)
4
Because 4 is an even number, no rounding takes
place. The number 4 itself is returned.
=EVEN(4.01)
6
Rounds to the next even integer, moving away
from 0.
Search JabSto ::

Custom Search