You Can't Coach That

When is sixty-five thousand equal to one hundred grand

I may be months behind the times with this but couldn’t resist having a dig at Microsoft.

Excel 2007, apart from introducing a whole new user interface, likes to mess with our minds. From the Microsoft support website:

When you perform a calculation in Excel 2007, the following behavior occurs:
• The result of the calculation is a number from 65534.99999999995 to 65535. The calculation is performed correctly. However, the result is incorrectly shown as 100000.
• The result of the calculation is a number from 65535.99999999995 to 65536. The calculation is performed correctly. However, the result is incorrectly shown as 100001.

Who cares if the calculation is correct if it doesn’t display correctly?

They have now issued a patch but oh dear!  Interestingly, there is no such problems with the latest Mac version.

I wish my salary was $65,535 and that my employer used Excel 2007 to calculate payroll.

“You can’t coach that”

Or you can look at it the other way around—what if your salary was $65,535 and the tax dept used Excel 2007 to calculate the taxes you owe the govt? :D

Yikes, I didn’t know this.  I like the way you couched this though.  That would work.  Lorna has a scarier way of doing this though.  Have a great day Coach. 

Lol, it looks like MS used an unsigned 16bit integer somewhere along the line and is causing a buffer/type overflow somewhere Kind of reminds me of the old Intel Pentium bug - (http://en.wikipedia.org/wiki/Pentium_FDIV_bug)

:D