Microsoft Office Tutorials and References
In Depth Information
If num_digitsis positive, the number is rounded to have the specified number
of decimal places. Use 2 for num_digitsto round to dollars and cents. If the
number of digits is negative, the number is rounded to the left of the decimal
point. For example, ROUND(117, 1) is rounded to the nearest 10, or a value of
Using a negative number for the number of digits provides an interest-
ing result. If you need to round a number to the nearest thousand, you
can indicate that it should be rounded to 3 decimal places. For ex-
ample, ROUND(1,234,567,-3) would be 1,235,000.
To override the rounding rules, you can use ROUNDDOWN or ROUNDUP:
The ROUNDDOWN function always rounds toward zero. For example,
=ROUNDDOWN(1.999,0) rounds to 1, and =ROUNDDOWN(-19.999,0) rounds
to 19. You might use this function when judging a contest in which if
the entrant does not completely finish a task, he or she does not get
credit for the unfinished portion of the task.
The result of the ROUNDUP function always rounds away from
zero. For example, =ROUNDUP(1.01,0) rounds up to 2, and
=ROUNDUP(-1.01,0) rounds to 2. You might use this function when
calculating prices because if the customer uses any fractional por-
tion of a product, he or she is charged for the complete product.
Figure 11.8 compares ROUND, ROUNDUP, and ROUNDDOWN.
Search JabSto ::

Custom Search