Documentation/How Tos/Calc: CEILING function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• Cos
• Sin
• Tan
• Cot
• Acos
• Acot
• Asin
• Atan
• Atan2
• Degrees
• Radians
• Pi

Hyperbolic

• Cosh
• Sinh
• Tanh
• Coth
• Acosh
• Acoth
• Asinh
• Atanh

Rounding and remainders

• Trunc
• Round
• Rounddown
• Roundup
• Ceiling
• Floor
• Even
• Odd
• Mround
• Int
• Quotient
• Mod

Logarithm/Powers

• Exp
• Power
• Log
• Ln
• Log10

Bessel functions

• Besseli
• Besselj
• Besselk
• Bessely

Miscellaneous

• Abs
• Combin
• Combina
• Convert
• Convert Add
• Countblank
• Countif
• Delta
• Erf
• Erfc
• Fact
• Factdouble
• Gcd
• Gcd Add
• Gestep
• Iseven
• Isodd
• Lcm
• Lcm Add
• Multinomial
• Product
• Rand
• Randbetween
• Seriessum
• Sign
• Sqrt
• Sqrtpi
• Subtotal
• Sum
• Sumif
• Sumsq

< Previous Page

Next Page >

CEILING

Returns a number rounded up to a multiple of another number.

Syntax:

CEILING(number; mult; mode)

number is the number that is to be rounded up to a multiple of mult.

If mode is zero or omitted, CEILING rounds up to the multiple above (greater than or equal to) number. If mode is non-zero, CEILING rounds up away from zero. This is only relevant with negative numbers.

Use mode=1 for compability if you have negative numbers and wish to export to MS Excel. In MS Excel this function only takes two arguments.

Example:

CEILING(4; 3)

returns 6, because 2*3 = 6 is the next multiple of 3 above 4.

CEILING(6; 3)

returns 6.

CEILING(-11; -2)

returns -10, rounding to the multiple above.

CEILING(-11; -2; 1)

returns -12, because with mode=1 the function rounds away from zero.

---

See Also

• FLOOR
• EVEN
• ODD
• MROUND

• INT
• TRUNC
• ROUND
• ROUNDDOWN
• ROUNDUP

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category