More than slightly concerning, considering I trust Excel to do basic arithmetic on a regular basis.
(see also
this thread)
-
Follow
Oops, something didn't work.
Sign In to be begin to follow this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.Getting "follow" information
Start following this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.Removing your "follow"
Setting up your "follow"
Did you know you can
sign up for email notifications?
-
CannotResolveSymbol
Microsoft: Who do you want to execute today?
-
Sven Groot
Don't worry... I'm a doctor.
bizarre!
-
Reading through the linked thread it seems to be a result of pre AND post processing of the value before it is rendered. The fact that A1-1 and A1+1 (where A1 is the SUM()) give different results lend some weight to this argument.
-
cheong
Recent Cheevo unlocked: You got cookied!
Banks using Excel to handle money shall have sleepless nights if upgraded to Excel 2007.
They should have busy time verifying the balance of accounts...
-
As a front office developer at an investment bank this scares the crap out of me.
MS fix this and fix it VERY quickly!!!
-
BlackTiger
If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
MS KNOWS BETTER!!!
Bloody hell!!! HOW?!?!?!?!
PS: "=IF(77.1, 77.0999)" rulezzz!
PPS: Never do any development/testing in India/China...
-
Bas
It finds lightbulbs.
BlackTiger wrote:
PPS: Never do any development/testing in India/China...
What does this have to do with anything? -
BlackTiger
If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
JonesJ wrote:
As a front office developer at an investment bank this scares the crap out of me.
MS fix this and fix it VERY quickly!!!
Don't think so.... Now MS needs to check ALL operations for ALL numbers...
-
BlackTiger
If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
Bas wrote:
BlackTiger wrote:
PPS: Never do any development/testing in India/China...
What does this have to do with anything?
Oh, sorry! I've completely forgot!
"Quality" doesn't means anything anymore, just "quantity"...
PS:
"QoS":
1. (old meaning) "Quality of Service"
2. (new maning) "Quantity of Sold"
-
BlackTiger
If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
But wait...
Perhaps Excel using some elements of quantum calculations?...
Probably in some parallel universe 2x2 is not quite 4? Who knows... -
Bas
It finds lightbulbs.
BlackTiger wrote:
Bas wrote:
BlackTiger wrote:
PPS: Never do any development/testing in India/China...
What does this have to do with anything?
Oh, sorry! I've completely forgot!
"Quality" doesn't means anything anymore, just "quantity"...
At the risk of channeling SirHomer:
-
YearOfTheLinuxDesktop
Seven of Niner! Resistance is Futile!
excel-lent! [6]
-
evildictaitor
I'll live forever, or die trying!
cheong wrote:Banks using Excel to handle money shall have sleepless nights if upgraded to Excel 2007.
They should have busy time verifying the balance of accounts...
Goldman sachs never upgraded from 98...
-
harumscarum
out of memory
that cant be good. Did you just randomly stumble on this?
-
figuerres
???
CannotResolveSymbol wrote:
More than slightly concerning, considering I trust Excel to do basic arithmetic on a regular basis.
(see also this thread)
some kind of display thing....
I just did 850 * 77 that gave 65,450.000
then the 850 * 77.100 gave 100,000.000
when I did =d8-c8 i got 85.00
but wnen i manualy entered 100,000 and 65,450 and did the subtract i got 34,550.00
so my off the cuff look says that internally the number is right but the display is wrong.
but yes MSFT needs to see this and jump on it.
-
There has already been a bug filed on this. My guess is that it will be addressed with SP1.
-
Minh
WOOH! WOOH!
Settle down. This is just part of MS Do More With Less campaign. You will now be able to do 100,000 with just 65,355. Quit complaining!
PS
This does look like somebody forgot to take out some debugging code, though. 65355 = 2^16 - 1 (or (Int16) -1) -
BlackTiger
If you stumbled and fell down, it doesn't mean yet, that you're going in the wrong direction.
Ok...
MS Stats:
Units of Vista sold: 850
Unit Price, GBP: 77.1
Sale Amount, GBP = 100,000
Yo!
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.