Function note

Below 10, GAMMA is a stored product down to a seed on (1,2)

FUNC.GAMMA

FN-GAMMA-001: Below 10, GAMMA is a stored product down to a seed on (1,2)

Detail for matching Excel's bits · measured · recorded 2026-11-04

With RN(v) meaning v rounded to 64 bits on the x87 unit and then stored to binary64, write x = i + y with GAMMA(1+y) on (1,2). For i from 2 to 9, GAMMA(x) is RN(t*GAMMA(1+y)), where t is the product (x-1)(x-2)...(1+y) taken from the top with each product RN. Each stage rounds, so the answers are not correctly rounded: at the fraction below, GAMMA(3.649...) is 1 unit high and GAMMA(5.649...) 1 unit low. The seed on (1,2) is a chain of stored products that has not been identified, and at x = 10 the route changes (FN-GAMMA-002).

Call and input routeInputsExcelCorrect valueRecorded in
GAMMA(1.6493607064491727)
cell-value2
number: 1.6493607064491727
0x3ffa63c80d581b40
0.900020234972592
0x3fecccf73c5e41af
—Excel 16.0 build 20527, Windows; bitness and CPU not recorded in this reading
GAMMA(3.6493607064491727)
cell-value2
number: 3.6493607064491727
0x400d31e406ac0da0
3.9328647235856704
0x400f7681c7bb23e9
3.93286472358567
0x400f7681c7bb23e8
Excel 16.0 build 20527, Windows; bitness and CPU not recorded in this reading
GAMMA(5.649360706449173)
cell-value2
number: 5.649360706449173
0x401698f2035606d0
66.72967981145608
0x4050aeb312f3b057
66.7296798114561
0x4050aeb312f3b058
Excel 16.0 build 20527, Windows; bitness and CPU not recorded in this reading

Correct value: mpmath gamma at 800 bits from the binary64 input, correctly rounded.

Correct value: mpmath gamma at 800 bits from the binary64 input, correctly rounded.

Basis: 2,000 of 2,000 fractions at each i from 2 to 9, from Excel's own GAMMA(1+y) (build 20527). The same formula fails at i = 10. Replayed for this note in exact rational arithmetic on 300 of those fractions: 300 of 300 at each i from 2 to 9, 61 of 300 at i = 10. Recorded GAMMA rows match 6,406 of 12,603 with stand-ins for the seed and the Stirling series, the worst by 49 units.

Open: The seed GAMMA(1+y) on (1,2): about five stored smooth quantities, seen as lines in its noise. Cody's rational matches 33% of it. Many closed families were tested and refuted.

Open: x < 1 and negative arguments.

Evidence and capture sources

Machine-readable note records