Thought this was worth posting, not sure how many people use Office 2007 but it may be good to double check your math after using it!



http://www.hexus.net/content/item.php?item=9936


Quote for the web link.



“850x77.1= erm, gimme a second... er, 100,000? Yeah, that'll do.
It's a given that every major software release, being the complex things that they are, has a few bugs here and there... but this multiplication bug in Excel 2007 is a pretty big oversight on Microsoft's part.

On a Google.groups message board, a poster has found a bug in Excel where anything that should resolve to 65,535 is displayed as 100,000.

In trying, and succeeding, to confirm this, other posters have discovered more flaws in Excel 2007's multiplication abilities, such as the following:

=5.1*12850
=10.2*6425
=20.4*3212.5
=40.8*1606.25
=77.1*850
=154.2*425
=212.5*308.4
=308.4*212.5
=425*154.2

All of these give incorrect answers... defaulting, it would appear, to 100,000.

Worse, is the formula is contained in a cell and then used as part of another formula, the result from that will be wrong as well as the original formula solution will be incorrect. Good, eh?

I've just spoken with one team of accountants using Excel 2007 and they're now checking all their formulas as this could have a major impact on their clients' spreadsheets.

The bug has been reported to Microsoft so you can expect a fix pretty damn soon... until then, keep that Texas Instruments calculator handy!”



-fm

9/25/2007 9:28:24 PM

SO FUCKING OLD AND THERE ARE OTHER THREADS ABOUT OFFICE 2007

NOT TO MENTION THE WRONG FUCKING FORUM

AND THAT NO BUSINESS WOULD BE STUPID ENOUGH TO CHANGE TO 2007 YET

[Edited on September 25, 2007 at 9:38 PM. Reason : 

9/25/2007 9:36:16 PM

Oh no! D: I hope the words aren't broken on it !!

9/25/2007 9:36:51 PM

message_section.aspx?section=3

9/25/2007 9:38:04 PM

ONE-HOUR SEASON PREMIERE THURSDAY, SEPTEMBER 27 9/8c

9/25/2007 9:39:43 PM

Quote :

"Thought this was worth posting"

if you have to think whether something is worth posting or not, it's probably not worth posting

WORST FIRST FUCKING POST EVER

GFTO lock suspend tar/feather

9/25/2007 10:05:21 PM

wow. this is one of the worst receptions i've ever seen a first post in the lounge get (that wasn't an ad, or a duplicate thread placed in every section by the same person)

take it easy, guys

9/25/2007 10:08:43 PM

^

seriously, buncha uppity nerds up in here.

9/25/2007 10:10:16 PM

i hate seeing other people addicted to this place

it is for their own good

9/25/2007 10:19:48 PM

There are in fact some offices currently upgrading to this particular system. Get your panties out of a wad, people. If I were using this system, I'd want to know the bugs in it.

9/25/2007 10:36:48 PM

http://www.thewolfweb.com/message_topic.aspx?topic=475722

9/25/2007 11:26:17 PM