Formulas and Functions

Chapter 13 Additional Examples and Topics 357
To Use this function Comments
Round a number up (away from
zero) to the specied number
of places
“ROUNDUP” (page 193 ) 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,200 and =ROUND(1155, -2)
also returns 1,200, since
rounding is away from zero.
=ROUND(-1125, -2) returns -1,200
and =ROUND(-1155, -2) also
returns -1,200.
Truncate a number at the
specied number of places
“TRUNC” (page 204) A positive number indicates
the number of digits (decimal
places) to the right of the
decimal separator to include
in the 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). Extra digits
are stripped from the number.
So =TRUNC(1125, -2) returns
1,100 and =TRUNC(1155, -2) also
returns 1,100.