Apple numbers Manual De Usuario

    Dictionary of Functions 

 

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.

  

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.

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."