Microsoft Office Tutorials and References
In Depth Information
Rounding Out Your Knowledge
3. Enter =ROUND( to begin the function entry.
4. Click the cell where you entered the number.
5. Enter a comma ( ,).
6. Enter a number to indicate how many decimal places to round to.
7. Type a ), and press the Enter key.
Rounding functions make the most sense when the first argument is a cell
reference, not an actual number. Think about it: If you know what a number
should appear as, you would just enter the number — you would not need a
function to round it.
Rounding in one direction
Excel has a handful of functions that round numbers either always up or
always down. That is, when rounding a number, the functions that round
down will always give a result that is lower than the number itself. Functions
that round up, of course, always give a higher number. These functions are
useful when letting the good ol’ ROUND function determine which way to
round just isn’t going to do.
A few of these rounding functions not only round in the desired direction
but even allow you to specify some additional ways of rounding. The EVEN
and ODD functions, for example, round respectively to the closest even or
odd number. The CEILING and FLOOR functions let you round to a multiple.
EVEN, ODD, CEILING, and FLOOR are discussed later in this section.
Directional rounding, pure and simple
ROUNDUP and ROUNDDOWN are similar to the ROUND function. The first
argument to the function is the cell reference of the number to be rounded.
The second argument indicates the number of decimal places to round to.
But unlike the plain old ROUND, the rounding direction is not based on the
halfway point of the next significant digit but rather on which function
For example, =ROUND(4.22,1) returns 4.2, but =ROUNDUP(4.22,1) returns
4.3. ROUNDDOWN, however, returns 4.2 because 4.2 is less than 4.22. Table
7-2 shows some examples of ROUNDUP and ROUNDDOWN.