Can I Spreadsheet?
← All functions

FLOOR.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
=FLOOR.MATH(24.3,5) Rounds 24.3 down to the nearest multiple of 5. Source: https://support.microsoft.com/en-us/office/floor-math-function-c302b599-fbdb-4177-ba19-2c2b1249a2f5 (worked example table) 20 20 Matched
=FLOOR.MATH(6.7) Significance and mode both omitted -> defaults to nearest integer (significance 1). Source: Microsoft FLOOR.MATH docs. 6 6 Matched
=FLOOR.MATH(-8.1,2) Negative number, mode omitted -> FLOOR.MATH's default for negative numbers rounds AWAY from zero (opposite default direction from CEILING.MATH's toward-zero default). -10 -10
Microsoft worked example: FLOOR.MATH(-8.1,2) = -10 ('rounds -8.1 down (away from 0) to the nearest integer that is a multiple of 2'). Note this default is the mirror image of CEILING.MATH's default (toward zero) for the same-shaped call.		 Matched
=FLOOR.MATH(-5.5,2,-1) Negative number with a nonzero mode argument -> reverses the default to round toward zero instead of away from zero. -4 -4
Microsoft worked example: FLOOR.MATH(-5.5,2,-1) = -4 ('rounds -5.5 toward 0 ... using a non-zero Mode, which reverses rounding direction').		 Matched

Docs & syntax