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.
Search JabSto ::




Custom Search