Next: CELLREF Up: A. Function Reference Previous: CCOUNT   Contents   Index

# CEIL, CEILING, XLCEILING

 Syntax: CEIL(X[, S]) CEILING(X[, S]) XLCEILING(X, S)

X = a numeric value
S = significance parameter

CEIL returns the smallest integer that is greater than or equal to X. If the optional significance parameter S is specified, CEIL returns X rounded up to the nearest multiple of S. When S is omitted it is assumed to be 1. The mathematical formula is given by:

CEILING is a synonym for CEIL. XLCEILING is designed to be compatible with the Excel CEILING function. It is functionally equivalent to CEIL, except that the parameter S is required.

If both X and S are specified, they must have the same sign, or an error is generated. S should not be set to 0. This will produce an error in CEIL. XLCEILING will return 0 in this case for consistency with the undocumented behavior of Excel's CEILING function.

Examples:

CEIL(5.5) = 6

CEIL(3.14159, 0.01) = 3.15

CEIL(E3) = -9, where E3 = -9.99

XLCEILING(-9.99, 1) = Error!

XLCEILING(-9.99, -1) = -10

CEILING(-9.99, -1) = -10 (in Excel compatibility mode)

CEILING(C17) = 1, where C17 = 1

Excel function: XLCEILING is compatible with Excel's CEILING (In Excel compatibility mode, the XL'' prefix is not used.)

Next: CELLREF Up: A. Function Reference Previous: CCOUNT   Contents   Index