|
Excel 2007 fails some simple multiplications - TechAmok
Excel 2007 fails some simple multiplications - [briefly] 07:01 PM EDT - Sep,26 2007 - post a comment
According to a post on the Microsoft Developer Network's Excel blog, the
spreadsheet application gives erroneous results for 12 basic multiplication
operations that a pocket calculator could handle flawlessly. Those operations
include 7.1*850, 5.1*12850, 10.2*6425, 20.4*3212.5, and a few others that add up
to either 65,535 or 65,536. In those cases, Excel erroneously returns a result
of 100,000:
Yesterday evening we were alerted to an issue in Excel 2007 (and Excel
Services 2007) involving calculation of numbers around 65,535. The first example
that we heard about was =77.1*850, but it became clear from our testing as well
as additional reports that this was just one instance where Excel 2007 would
return a value of 100,000 instead of 65,535. The majority of these additional
reports were focused on multiplication (ex. =5.1*12850; =10.2*6425; =20.4*3212.5
), but our testing showed that this really didn't have anything do to with
multiplication - it manifested itself with many but not all calculations in
Excel that should have resulted in 65,535 (=65535*1 and =16383.75*4 worked for
instance). Further testing showed a similar phenomenon with 65,536 as well. This
issue only exists in Excel 2007, not previous versions.
|
|
Add your comment (free registrationrequired)
Short overview of recent news articles |
Sep,21 2025 Race Highlights: A Swing In The Drivers' Title Fight? | 2025 Sep,21 2025 BYD Yangwang U9 Hits 496.22 KM/H - EV Supercar Speed Record Sep,21 2025 I'm FIRST to Unbox The World's Biggest TV Sep,21 2025 Samsung Begins Rollout of Android 16 to Rest of Lineup Sep,21 2025 iOS 26 Now Available, with Visual Intelligence Sep,21 2025 Apple's iPhone 17 Series is Nearly Hack-Proof Sep,21 2025 Qualifying Highlights - 2025 Azerbaijan Grand Prix Sep,20 2025 iPhone 17 Pro vs Samsung S25 Ultra Camera Comparison! Sep,20 2025 iPhone Air Durability test -- I AM SHOCKED Sep,15 2025 Microsoft warns Office 2016/2019 users to switch to the cloud as Sep,15 2025 Get Windows 11 25H2 Right Now Sep,14 2025 iPhone 17 Pro VS iPhone 16 Pro VS iPhone 15 Pro VS iPhone 14 Pro Sep,11 2025 What's the AMD Alternative to an RTX 5070? Sep,10 2025 Apple got my wife, they might get me next... Sep,09 2025 Which Phone Has The Fastest Wi-Fi 7? Sep,09 2025 Apple Event - September 9 Sep,08 2025 Ferrari F430 *MANUAL* with TUBI EXHAUST SCREAMING on the AUTOBAHN! Sep,08 2025 AMD Adrenalin 25.9.1 Driver Sep,08 2025 Google Brings AI Text Tools to its Keyboard Sep,06 2025 The Fastest Lap In F1 History: Max Verstappen's Pole Lap | 2025 Sep,06 2025 You can't download and install Windows 11 25H2 yet as Microsoft Sep,04 2025 A House of Dynamite - Official Teaser (2025) Rebecca Ferguson, Greta Sep,04 2025 RTX 5060 Ti 16GB + Ryzen 5 5600 : Test in 17 Games Sep,02 2025 BUGONIA Trailer 2 (2025) Emma Stone, Jesse Plemons Sep,02 2025 Huawei unveils world-leading AI supercharged hard drive to power Sep,01 2025 AM4 Lives: AMD Ryzen 5 5500X3D CPU Review & Benchmarks Aug,29 2025 I was wrong, iPhone IS better than Android...- 30 Day iPhone Aug,29 2025 303KM/H BMW X5 M50i GPOWER SOUNDS LIKE THUNDER Aug,29 2025 NVIDIA GeForce 581.15 WHQL drivers Aug,28 2025 Apple Intelligence vs Galaxy AI / Google Pixel AI / Xiaomi HyperAI - Aug,28 2025 The Woman in Cabin 10 - Official Trailer Aug,28 2025 YANGWANG U9 Breaks Global EV Top Speed Record Aug,26 2025 AMD B850 Motherboard Roundup: Sub $200 Models Aug,25 2025 Gamers Nexus: Our Channel Could Be Deleted Aug,24 2025 2025 Audi A5 E-Hybrid 299HP "250KMH is back!!" // REVIEW on Aug,23 2025 I Can't Stop You From Buying This... But I'll Try - GeForce RTX Aug,23 2025 NVIDIA GeForce 581.08 WHQL Driver Aug,21 2025 Murcielago with flames chasing an F1 car on highway (2025) Aug,18 2025 Windows 11 24H2 Security Update Causes SSD/HDD Failures and Aug,17 2025 Samsung Galaxy Z Fold 7 - Tips, Tricks & Hidden Features!
>> News Archive <<
| |
|