Microsoft Office Tutorials and References

In Depth Information

**Syntax:**

Figure 11.7.

Figure 11.7.
TRUNC

TRUNC and

and INT

INT are nearly identical, except when the numbers be-

are nearly identical, except when the numbers be-

come negative.

come negative.

Syntax:

=ROUND(number,num_digits)

=ROUNDUP(number,num_digits)

=ROUNDDOWN(number,num_digits)

Three more functions
—
ROUND, ROUNDUP, and ROUNDDOWN
—
round a number

to a specified number of decimal places. They all take the following argu-

ments:

•
number

number
—
This is the number you want to round.

•
num_digits

num_digits
—
This specifies the number of digits to which you want to

round number.

With ROUND, if the number of digits is zero, the number is rounded to the

nearest integer, following these rules:

•
Values up to 0.4999999 are rounded toward zero. For example,

ROUND(1.49999,0) results in 1, and ROUND(-1.49999,0) results in
–
1.

•
Values of 0.5 and above are rounded away from zero. For example,

ROUND(1.5,0) results in 2, and ROUND(
–
1.5,0) results in
–
2.