65,536 Lashes for Microsoft

Microsoft should be more abashed than it seems to be about a bug in Excel 2007 that causes certain multiplications that produce results very close to 65,535 or 65,536 to display incorrect answers. For example, if you multiply 850x77.1[see note below], the result is displayed as 100,000. The correct answer, 65,335, is stored and that’s what is used in most, but not all, operations when the cell is referenced.

To continue reading this article you must be a Bloomberg Professional Service Subscriber.