I found a bug in the Excel GCD function.

I blogged about it he
http://davidvs.blogspot.com/2006/04/bug-in-excel.html

To summarize, try typing into a cell
=GCD(6*0.018*1000,1000)
and you'll see that Excel gets confused. :-(

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

On Tue, 4 Apr 2006 22:01:01 -0700, David V.S. <David
wrote:

I found a bug in the Excel GCD function.

I blogged about it he
http://davidvs.blogspot.com/2006/04/bug-in-excel.html

To summarize, try typing into a cell
=GCD(6*0.018*1000,1000)
and you'll see that Excel gets confused. :-(

----------------

There seems to be some issue as to how the result is truncated to an integer
within the GCD function as documented.

For example:

=GCD(TRUNC(6*0.018*1000),1000)--4

Although

A1: =6*0.018*1000
A2: 108
A3: =A1=A2 -- TRUE


--ron