Apple numbers User Manual

    Dictionary of Functions 

 

  

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.

  

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.

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.

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.