Microsoft Office Tutorials and References

In Depth Information

**Rounding Out Your Knowledge**

Table 7-2 Using the ROUNDUP and ROUNDDOWN Functions

Example of Function

Result

Comment

=ROUNDUP

(150.255,0)

151

The second argument is 0. The result is

rounded up to the next higher integer,

regardless of the fact that the decimal

portion would normally indicate the rounding

would go to the next lower integer.

=ROUNDUP

(150.255,1)

150.3

The second argument is 1. The result is

rounded to a single decimal point. Note

that the full decimal of .255 rounds up to.3.

This would also happen with the standard

ROUND function.

=ROUNDUP

(150.255,2)

150.26

The second argument is 2; the result is

rounded to two decimal places. Note that

the full decimal of .255 becomes .26. This

would also happen with the standard

ROUND function.

=ROUNDUP

(150.255,3)

150.255

The second argument is 3, and there are

three decimal places. No rounding takes

place.

=ROUNDDOWN

(155.798,0)

155

The second argument is 0. The result is

rounded down to the integer portion of

the number, regardless of the fact that

the decimal portion would normally

indicate that the rounding would go to the

next higher integer.

155.7

The second argument is 1. The result is

rounded to a single decimal place. Note

that the full decimal of .798 rounds down

to .7. The standard ROUND function

would round the decimal up to .8.

=ROUNDDOWN

(155.798,1)

155.79

The second argument is 2. The result is

rounded to two decimal places. Note that

the full decimal of .798 becomes .79. The

standard ROUND function would round

the decimal up to .8.

=ROUNDDOWN

(155.798,2)

=ROUNDDOWN

(155.798,3)

155.798

The second argument is 3, and there are

three decimal places. No rounding takes

place.