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 route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
=BESSELJ(0,0)formula-literal | As typed | 1.000000002831410x3ff0000000c292b1 | 10x3ff0000000000000 | 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
- DnaCalc · crates/calc-func/tests/captures/catalogue/sections/dc96l3_bessel.capture.json da3ecc4fb19a3a5529708c311d0e8f05688ac165 · sheet dc96l3_bessel, row 309, column 4 recorded formula and results with environment
- DnaCalc · crates/calc-func/src/ported/bessel.rs da3ecc4fb19a3a5529708c311d0e8f05688ac165 · spot_values_record_exact_controls_and_known_gaps recorded answer pinned in the product test
- DnaCalc · crates/calc-func/src/ported/bessel_rational.rs da3ecc4fb19a3a5529708c311d0e8f05688ac165 · J0_NUM, J0_DEN and j0 current licensed published-method candidate; constant-term ratio at zero
- DnaCalc · crates/calc-func/tests/captures/catalogue/sections/dc96l3_bessel.capture.json da3ecc4fb19a3a5529708c311d0e8f05688ac165 · sheet dc96l3_bessel, row 309, column 4; formulas, observations, saved and reopened one capture with raw, saved and reopened views; not three independent runs