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.