Function note

BESSELJ at zero and order zero is slightly above one

FUNC.BESSELJ

FN-BESSELJ-001: BESSELJ at zero and order zero is slightly above one

Excel differs from the mathematical answer · measured · recorded 2026-11-06

In the retained catalogue capture, BESSELJ(0,0) returns 1.00000000283141 (0x3ff0000000c292b1), while the mathematical Bessel function J0(0) is exactly 1. The raw answer, saved workbook cache and answer after reopening retain that same value. This is one captured input on the named Excel environment, not a general accuracy statement.

Call and input routeInputsExcelCorrect valueRecorded in
=BESSELJ(0,0)
formula-literal
As typed1.00000000283141
0x3ff0000000c292b1
1
0x3ff0000000000000
Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), AMD Ryzen 7 4800H, en-ZA, workbook Compatibility Version 1

Correct value: Exact identity J0(0)=1: in the defining series in NIST DLMF 10.2.2 (https://dlmf.nist.gov/10.2#E2), only the constant term remains at order zero and x=0.

Basis: One formula-literal control at sheet dc96l3_bessel, row 309, column 4 in the landed capture. Its environment is Excel 16.0.20527.20088, Windows 64-bit, AMD Ryzen 7 4800H, en-ZA, workbook Compatibility Version 1. The raw and reopened binary64 encodings are both 3ff0000000c292b1; the saved numeric text is 1.00000000283141. The product test also pins these result bits.

Inferred: The current published small-J0 implementation evaluates its constant coefficients as 57568490574/57568490411 at x=0, which produces the recorded bits. That source-level explanation does not prove that Microsoft uses the same private program.

Open: The generic J/Y numerical bodies retain disagreements on other inputs; this control does not identify the full seed or recurrence program.

Evidence and capture sources

Machine-readable note records