Home › Functions › Math & Trig › CEILING.MATH
fx
CEILING.MATH
Math & Trig  ·  Since: Excel 2003  ·  9 languages

Here is the formula syntax and use of the CEILING.MATH function in Microsoft Excel.

🌐 Translations

English CEILING.MATH
Deutsch OBERGRENZE.MATHEMATIK
Français PLAFOND.MATH
Español MULTIPLO.SUPERIOR.MAT
Italiano ARROTONDA.ECCESSO.MAT
Português TETO.MAT
Nederlands AFRONDEN.BOVEN.WISK
Polski ZAOKR.W.GÓRĘ.MATEMATYCZNE
Русский ОКРВВЕРХ.МАТ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

CEILING.MATH(number,[significance],[mode])

Arguments

number (required) — (must be between -2.229E-308.and 9.99E+307.)
significance (optional) — This is the number of significant digits after the decimal point to which number is to be rounded.
mode (optional) — This controls whether negative numbers are rounded toward or away from zero.

▶ Examples

=CEILING.MATH(6.7)
=CEILING.MATH(24.3,5)
=CEILING.MATH(-8.1,2)

Related functions

Copied to clipboard