Microsoft Office Tutorials and References
In Depth Information
Rounding Out Your Knowledge
Here’s how to use either the ROUNDUP or ROUNDDOWN function:
1. In a cell of your choice, enter a number with a decimal portion.
2. Position the cursor in the cell where you want the results to appear.
3. Enter either =ROUNDUP( or =ROUNDDOWN( to begin the function
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 to the multiple of choice
The FLOOR and CEILING functions take directional rounding to a new level.
With these functions, the second argument is a multiple to which to round to.
What does that mean?
Well, imagine this: You’re a human resources manager and you need to
prepare a summary report of employee salaries. You don’t need the figures to be
reported down to the last penny, just rounded to the closest $250 multiple.
Either FLOOR or CEILING can be used to do this. For this example, FLOOR
can be used to round down to the closest multiple of $250 that is less than
the salary, or CEILING can be used to round up to the next $250 multiple
greater than the salary. Figure 7-6 shows how both FLOOR and CEILING
return rounded values.
round to a
FLOOR and CEILING exceed the rounding ability of ROUND, ROUNDUP,
and ROUNDDOWN. These three functions can use the positioning of digit