Apple Numbers '08 - Manual (Page 212)

212 Chapter 12 Dictionary of Functions
CEILING
The CEILING function rounds a number away from zero to the nearest multiple of the
specified factor.
CEILING(number, factor)
 number: A number, numeric expression, or references 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 down (toward zero) instead of up, use the FLOOR function.
Other functions related to rounding numbers: INT, ROUND, ROUNDUP, ROUNDDOWN,
TRUNC.
CHAR
The CHAR function returns the character that corresponds to a numeric Unicode
character code.
CHAR(code-number)
 code-number: A number from 1 through 65535 for which you want to generate the
corresponding character.
Examples
AVERAGEA(A1:A4) returns 2.5 if cells A1 through A4 contain 4, a, 6, b. The text values are counted as
zeros in the sum of 10 and included in the count of values (4). Compare with AVERAGE(A1:A4), which
ignores the text values completely for a sum of 10, a count of 2, and an average of 5.
AVERAGEA(A1:A4) returns 4 if cells A1 through A4 contain 5, a, TRUE, 10. The text value counts zero
and TRUE counts 1 for a sum of 16 and a count of 4.
AVERAGEA(A1:A4) returns 0.25 if cells A1 through A4 contain FALSE, FALSE, FALSE, TRUE. Each FALSE
counts zero and TRUE counts 1 for a sum of 1 and a count of 4.
Examples
CEILING(0.25,1) returns 1.
CEILING(1.25,1) returns 2.
CEILING(-1.25,-1) returns -2.
CEILING(5,2) returns 6.
CEILING(73,10) returns 80.
CEILING(7,2.5) returns 7.5.