Can I Spreadsheet?
← All functions

CEILING.MATH

Supported, behaves as documented

Category: Math and trigonometry · Last tested 2026-07-04

Support matrix

EngineDocumentedLive-testedVerdict
Excel Yes Not yet n/a
Google Sheets Yes Not yet n/a
LibreOffice Calc No Yes (24.2.7.2, 2026-07-04) Supported, behaves as documented

Executed test cases

LibreOffice Calc 24.2.7.2 (tested 2026-07-04)

FormulaDescriptionResultExpectedVerdict
=CEILING.MATH(24.3,5) Rounds 24.3 up to the nearest multiple of 5. Source: https://support.microsoft.com/en-us/office/ceiling-math-function-80f95d2f-b499-4eee-9f16-f795a8e306c8 (worked example table) 25 25 Matched
=CEILING.MATH(6.7) Significance and mode both omitted -> defaults to nearest integer (significance 1). Source: Microsoft CEILING.MATH docs. 7 7 Matched
=CEILING.MATH(-8.1,2) Negative number, mode omitted -> unlike the modeless legacy CEILING function, CEILING.MATH's default for negative numbers rounds TOWARD zero. -8 -8
Microsoft worked example: CEILING.MATH(-8.1,2) = -8 ('rounds -8.1 up (toward 0) to the nearest multiple of 2'). This is the modern, explicit-mode successor to legacy CEILING and was designed to match LibreOffice/ODF's CEILING(...,...,Mode) semantics for the default case.		 Matched
=CEILING.MATH(-5.5,2,-1) Negative number with a nonzero mode argument -> rounds away from zero instead of the toward-zero default. -6 -6
Microsoft worked example: CEILING.MATH(-5.5,2,-1) = -6 ('rounds -5.5 down (away from 0) ... with a mode of -1'). Mode only affects negative numbers; any nonzero mode reverses the default direction.		 Matched

Docs & syntax