Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
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 version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=CEILING.MATH(6.7)
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
ABS
ACOS
ACOSH
ACOT
ACOTH
AGGREGATE
ARABIC
ASIN
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›