Formulas and Functions

To Use this function Comments
Round a number to the
specied number of places
“ROUND” (page 191 ) A positive number indicates
the number of digits (decimal
places) to the right of the
decimal separator to include in
the rounded number. A negative
number indicates the number of
digits to the left of the decimal
separator to replace with zeros
(the number of zeros at the end
of the number). The number
is rounded based on this. So
=ROUND(1125, -2) returns
1,100 and =ROUND(1155, -2)
returns 1,200. Rounding
is away from zero, so
=ROUND(-1125, -2) returns -1,100
and =ROUND(-1155, -2) returns
-1,200.
Round a number down (toward
zero) to the specied number
of places
“ROUNDDOWN” (page 192 ) A positive number indicates
the number of digits (decimal
places) to the right of the
decimal separator to include in
the rounded number. A negative
number indicates the number of
digits to the left of the decimal
separator to replace with zeros
(the number of zeros at the end
of the number). The number
is rounded based on this. So
=ROUND(1125, -2) returns
1,100 and =ROUND(1155, -2)
also returns 1,100, since
rounding is toward zero.
=ROUND(-1125, -2) returns -1,100
and =ROUND(-1155, -2) also
returns -1,100.
356 Chapter 13 Additional Examples and Topics