|
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 |
Apr,23 2024 ATLAS | Official Trailer | Netflix Apr,22 2024 The World's Fastest CPU (Technically...) - Intel i9-14900KS Apr,22 2024 We can do THIS now! - Lumafield CT Scanner Apr,21 2024 Huawei Pura 70 Ultra - Apple Should be WORRIED Apr,21 2024 Sony 2024 TV Lineup Revealed Apr,20 2024 ICE - A Thousand Suns / Episode 1 Apr,20 2024 Minisforum V3 AMD Tablet Review Apr,20 2024 AMD & Intel SLASH CPU Prices! Apr,20 2024 EK is Imploding: Not Paying Employees, Partners, & Suppliers Apr,20 2024 Backing Up My NAS To My... Parents' House? Apr,20 2024 NEW Ryzen APU BEATS RTX 40 GPUs! Apr,20 2024 (Live) Black Tape Project - All New Raw and Uncut - LA Fashion Week Apr,19 2024 NVIDIA Geforce 552.22 WHQL Driver Apr,19 2024 You Deserve this much OLED - AORUS CO49DQ Apr,19 2024 Unreal Engine 5.4 looks ULTRA PHOTOREALISTIC Apr,18 2024 Radeon RX 5700 XT vs. 7700 XT, 2024 Revisit Apr,18 2024 I Will Build You a PC Right Now! Apr,17 2024 These games carry REAL security risks! BEWARE! Apr,17 2024 Visible First to Offer Annual Payment Plan, with Discount up to 26% Apr,17 2024 Is Coding Still Worth Learning in 2024? Apr,17 2024 All New Atlas - Boston Dynamics Apr,16 2024 The NEW Chip Inside Your Phone! (NPUs) Apr,16 2024 XPS 14 vs 14" MacBook Pro - Apple just KILLED Intel! Apr,15 2024 The Most 2024 Laptop - Razer Blade 14 Review Apr,15 2024 NEVER install these programs on your PC... EVER!!! Apr,14 2024 Use Live Translate on Galaxy S24 series to translate a call's Apr,14 2024 I Tried a Non-Invasive Blood Sugar Watch. Miracle or Scam? Apr,13 2024 Samsung Galaxy Ring - This Just Got Interesting Apr,13 2024 Piracy Is Over Party - WAN Show April 12, 2024 Apr,13 2024 Conan O'Brien Needs a Doctor While Eating Spicy Wings Apr,13 2024 Beatbox Jcob recreats every sound Apr,13 2024 Intel is Gunning for NVIDIA Apr,13 2024 Building a Budget DIY Home Surveillance System Apr,12 2024 Lenovo Yoga Buyers Guide - What's the Best Thin and Light Laptop Apr,11 2024 DARK MATTER Trailer (2024) New Sci-Fi Movies 4K Apr,11 2024 How to Build a PC, the last guide you'll ever need! (2024 Update) Apr,10 2024 Intel 300 CPU Review - The Pentium Replacement is Finally Here... Apr,10 2024 Wubuntu, the Dubious Linux Windows Apr,09 2024 A Lite Version Of Windows 11 To Be Released This Year Apr,09 2024 This $150 Smartphone might be All You Need
>> News Archive <<
| |
|