Hello,

I occasionally find an error on the GCD function in Excel 2013

to find greatest common divisor from 2 numbers which are results of COMBIN by GCD formula, it gives wrong result.

Can anyone check for the reason?

Example:

• A = COMBIN(9, 4) = 126
  
• B = COMBIN(10, 6) = 210
  
• If i use GCD(A, B), the result is 1 while it must be 42.
• if use the GCD formula directly with the number (not reference), it gives right result GCD (126, 210) = 42

does anyone explain to me? or is it the bug from Excel

Thank you

DanDC

• Edited by DanDC 13 hours 50 minutes ago