At the heart of conVERGENce
About Us About Us Services News Tools

News - Excel 2007 Multiplication Bug

Sep 25, 2007 Excel 2007 Multiplication Bug
Several researchers have reported a serious multiplication bug in Excel 2007, which has been reported to Microsoft. The example that first came to light is '=850*77.1' — which gives a result of 100,000 instead of the correct 65,535. It seems that any formula that should evaluate to 65,535 will act strangely.

Suppose the formula is in A1. =A1+1 returns 100,001, which appears to show the formula is in fact 100,000... =A1*2 returns 131,070, as if A1 had 65,535 (which it should have been). =A1*1 keeps it at 100,000. =A1-1 returns 65,534. =A1/1 is still 100,000. =A1/2 returns 32767.5."
<FULL STORY>
Consulting
Development
Operations

NEWS
15.09.2015 Cisco router break-ins bypass cyber defenses
Security researchers say they have uncovered clandestine attacks across three continents on the routers that direct traffic around the Internet, potentially allowing suspected cyberspies to harvest vast amounts of data while going undetected.
03.02.2011 River of IPv4 addresses officially runs dry
In a ceremony in Miami this morning, the final five blocks of IPv4 addresses were given out to the five Regional Internet Registries that further distribute IP addresses to the far corners of the planet. The five RIRs still have tens of millions of addresses as working inventory, but once those addresses are given out, it's over.
27.05.2010 Are you ready for the big internet crunch?
The internet as we know it is reaching its limits.  Within 18 months it is estimated that the number of new devices able to connect to the world wide web will plummet as we run out of "IP addresses" -- the unique codes that provide access to the internet for everything from PCs to smart phones.  
Copyright 2018 © Vergen Inc.