Apple Numbers '08 Manual de usuario descargar pdf (Pagina 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."

1 2 ... 227 228 229 230 231 232 233 234 235 236 237 ... 294 295

Sin comentarios

Apple Numbers '08 Manual de usuario Pagina 232