Apple Numbers '08 - Manual (Page 232)

232 Chapter 12 Dictionary of Functions
FIXED
The FIXED function rounds a number to the specified number of decimal places and
then converts the result to text.
FIXED(number, [places], [commas])
 number: A number.
 places: Optional; a number specifying the number of decimal places you want in the
result.
 commas: Optional Boolean value; specifies whether to use position separators in the
whole portion of the resulting number.
FALSE or 0 leaves out position separators in the resulting number.
TRUE, 1, or omitted includes position separators in the resulting number.
FLOOR
The FLOOR function rounds a number toward zero to the nearest multiple of the
specified factor.
FLOOR(number, factor)
 number: A number, numeric expression, or reference to a cell containing a numeric
expression.
 factor: The number whose multiples you want to round to. factor must have the
same sign as number.
Notes
To round away from zero instead of toward zero, use the CEILING function.
Other functions related to rounding numbers: INT, ROUND, ROUNDUP, ROUNDDOWN,
TRUNC.
Examples
FIXED(6789.123, 2) returns "6,789.12."
FIXED(6789.123, 1, 1) returns "6789.1."
FIXED(6789.123, -2) returns "6,800."
FIXED(12.4, 0) returns "12."
FIXED(12.5, 0) returns "13."
FIXED(4, -1) returns "0."
FIXED(5, -1) returns "10."