Function note

ERROR.TYPE of #BUSY! is 0

FUNC.ERROR.TYPE

FN-ERROR.TYPE-001: ERROR.TYPE of #BUSY! is 0

Quirk · measured · recorded 2026-11-04

With #BUSY! in the referenced cell, ERROR.TYPE gives 0, not one of its numbers for an error and not #N/A. The cell still counts as an error elsewhere: ISERROR is TRUE and IFERROR takes its fallback.

Call and input routeInputsExcelCorrect valueRecorded in
=ERROR.TYPE(B1)
cell-value2		B1: #BUSY!0
0x0000000000000000		—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=ISERROR(B1)
cell-value2		B1: #BUSY!TRUE—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=IFERROR(B1,7)
cell-value2		B1: #BUSY!7
0x401c000000000000		—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA
=N(B1)
cell-value2		B1: #BUSY!#BUSY!—Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA

Basis: Four recorded readings of one cell holding #BUSY!.

Evidence and capture sources

Machine-readable note records