Function note

GCD and LCM accept 2^53 itself, not only values below it

FUNC.GCD · FUNC.LCM

FN-GCD-001: GCD and LCM accept 2^53 itself, not only values below it

Documentation differs from behaviour · measured · recorded 2026-11-04

GCD accepts an operand equal to 2^53, and LCM accepts an operand or a result equal to 2^53. Only values above 2^53 give #NUM!.

Documentation: If a parameter to GCD is >=2^53, GCD returns the #NUM! error value. If LCM(a,b) >=2^53, LCM returns the #NUM! error value. Source documentation · Source documentation

Call and input routeInputsExcelCorrect valueRecorded in
GCD(9007199254740992, 1)
cell-value2
number1: 9007199254740992
0x4340000000000000
number2: 1
0x3ff0000000000000
1
0x3ff0000000000000
—Excel 16.0 build 20430, Windows 64-bit, CPU not recorded in this capture
LCM(9007199254740992, 2)
cell-value2
number1: 9007199254740992
0x4340000000000000
number2: 2
0x4000000000000000
9007199254740992
0x4340000000000000
—Excel 16.0 build 20430, Windows 64-bit, CPU not recorded in this capture
GCD(9007199254740994, 0)
cell-value2
number1: 9007199254740994
0x4340000000000001
number2: 0
0x0000000000000000
#NUM!—Excel 16.0 build 20430, Windows 64-bit, CPU not recorded in this capture

Basis: All recorded rows match after the boundary change: GCD 7,966 of 7,966 and LCM 7,967 of 7,967.

Evidence and capture sources

Machine-readable note records