software

I found a bug in the Excel GCD function.

I blogged about it he
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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

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

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

gt;I found a bug in the Excel GCD function.
gt;
gt;I blogged about it he
gt;davidvs.blogspot.com/2006/04/bug-in-excel.html
gt;
gt;To summarize, try typing into a cell
gt;=GCD(6*0.018*1000,1000)
gt;and you'll see that Excel gets confused. :-(
gt;
gt;----------------

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)--gt;4

Although

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