Function note

FLOOR of zero is +0, even with significance 0

FUNC.FLOOR

FN-FLOOR-001: FLOOR of zero is +0, even with significance 0

Quirk · measured · recorded 2026-11-04

FLOOR(0,0) and FLOOR(-0,0) return +0. A zero number with a negative significance also returns +0, not #NUM!. Only a nonzero number with significance 0 gives #DIV/0!.

Call and input routeInputsExcelCorrect valueRecorded in
FLOOR(0, 0)
cell-value2		number: 0
0x0000000000000000
significance: 0
0x0000000000000000		0
0x0000000000000000		—Excel 16.0 build 20430, Windows 64-bit, CPU not recorded in this capture
FLOOR(-0, -2)
cell-value2		number: -0
0x8000000000000000
significance: -2
0xc000000000000000		0
0x0000000000000000		—Excel 16.0 build 20430, Windows 64-bit, CPU not recorded in this capture
FLOOR(1, 0)
cell-value2		number: 1
0x3ff0000000000000
significance: 0
0x0000000000000000		#DIV/0!—Excel 16.0 build 20430, Windows 64-bit, CPU not recorded in this capture

Basis: 12 recorded readings.

Evidence and capture sources

Machine-readable note records