IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Excel 2007 can't multiply.
[link|http://www.theinquirer.net/gb/inquirer/news/2007/09/25/math-bug-found-excel|The Inquirer]:

A THREAD on Google Group microsoft.public.excel reveals that Excel 2007 loses its grip with arithmetic that involves the number 65,535.

Several examples are shown, perhaps the simplest of which is the calculation ( 850 X 77.1 ), which should produce 65,535 but instead returns 100,000.


2^16 - 1 can't be a coincidence.

(It works fine on Excel 97.)

The thread is [link|http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/2bcad1a1a4861879/2f8806d5400dfe22?hl=en#2f8806d5400dfe22|here], it lists lots of other examples (and is an interesting read).

Cheers,
Scott.
New hmm right around that pesky 64k boundry
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 51 years. meep

reach me at [link|mailto:bill.oxley@cox.net|mailto:bill.oxley@cox.net]
New A statistics program I used to use, Statgraphics...
...([link|http://www.statgraphics.com/|it's still around, it seems]), used -32768 as code for "missing value". That's the same thing, only interpreted as a signed in stead of an unsigned integer, isn't it?

I always used to wonder what you'd do if your data actually included the actual value -32768... (OK, no, I didn't. But I could wonder what a *statistically naive* user would do. :-)


   [link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Ah, the Germans: Masters of Convoluted Simplification. — [link|http://www.thetruthaboutcars.com/?p=1603|Jehovah]
New That's the problem with using a value as a sentinel.
Although -32768 isn't *too* bad, because in a 16-bit signed integer, there isn't a +32768.

Wade.


Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please



-- "Anything but Ordinary" by Avril Lavigne.

· my ·
· [link|http://staticsan.livejournal.com/|blog] ·
· [link|http://yceran.org/|website] ·

New [dup]
[double-bouonce error]


Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please



-- "Anything but Ordinary" by Avril Lavigne.

· my ·
· [link|http://staticsan.livejournal.com/|blog] ·
· [link|http://yceran.org/|website] ·

Expand Edited by static Sept. 26, 2007, 06:00:24 AM EDT
New Interestingly enough
I put 850 in a1 and 77.1 in b1
the formula in c1 =a1*b1 put 100000 in c1
but the formula = c1/2 returned 32767.5 rather than 50000

hmmmm

A
Play I Some Music w/ Papa Andy
Saturday 8 PM - 11 PM ET
All Night Rewind 11 PM - 5 PM
Reggae, African and Caribbean Music
[link|http://westcottradio.org|Tune In]
New Live by the MS sword
Die by the MS sword
New Re: Live by the MS sword
is that anything like MS Word
Play I Some Music w/ Papa Andy
Saturday 8 PM - 11 PM ET
All Night Rewind 11 PM - 5 PM
Reggae, African and Caribbean Music
[link|http://westcottradio.org|Tune In]
New Point to andread!
New An explanation of sorts
It appear to mainly be a display issue with a particular range of floating point results:

[link|http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx|http://blogs.msdn.co...issue-update.aspx]
--
Chris Altmann
     Excel 2007 can't multiply. - (Another Scott) - (9)
         hmm right around that pesky 64k boundry -NT - (boxley)
         A statistics program I used to use, Statgraphics... - (CRConrad) - (2)
             That's the problem with using a value as a sentinel. - (static)
             [dup] - (static)
         Interestingly enough - (andread) - (3)
             Live by the MS sword - (crazy) - (2)
                 Re: Live by the MS sword - (andread) - (1)
                     Point to andread! -NT - (hnick)
         An explanation of sorts - (altmann)

Powered by a bowl of Giorgio's Fettucini Primavera and two rabid Viking weasels!
63 ms