Microsoft Office Tutorials and References

In Depth Information

**Syntax:**

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

120.

Note

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.