Contest: Excel T-Shirt Captions

[schielrn]

Maybe:

(850*77.1)-1 = 65534
(850*77.1)+1 = 100001

 

[cornflakegirl]

Huh? :thick:

 

[RoryA]

Excel 2007 calculation bug...

 

[Greg Truby]

Maybe:

(850*77.1)-1 = 65534
(850*77.1)+1 = 100001

Excel 2007 calculation bug...

Rory,

I do get correct results in Excel 2007. Has this been fixed?

 

[RoryA]

Yes a fix was released relatively quickly, though it was the subject of a certain amount of ridicule for a while!

 

[schielrn]

I have not seen a fix as I still get the wrong results for the +1. If you have (850*77.1) do you get 100000?

Also even if you copy and paste values it still handles it strangely.

 

[RoryA]

It's in SP1 and is also available separately (or used to be)

 

[schielrn]

ah I see, I do not have SP1. Thanks.

 

[NateO]

Yes a fix was released relatively quickly, though it was the subject of a certain amount of ridicule for a while!

I seem to recall SP3 for Office 2003 creating a few headaches, too. Stuff just stopped working, more on the Access side, iirc.

 

[RoryA]

Oh yeah, and some of the Access glitches were really odd as well as really frustrating!