try 850*77.1 or 12850*5.1
wrong answers whoops!
for those that use excel


« Next Oldest  Next Newest »

▼
10172007, 02:54 PM
try 850*77.1 or 12850*5.1 wrong answers whoops! ▼
10172007, 03:08 PM
Excel yields 65535 as my calculator. I don't get the joke... Edited: 17 Oct 2007, 3:12 p.m.
10172007, 04:06 PM
There was a brief discussion about this here, a few weeks ago, with some speculation as to whether this is a calculation bug or a display bug: http://www.hpmuseum.org/cgisys/cgiwrap/hpmuseum/archv017.cgi?read=125330#125330  Thomas ▼
10172007, 05:33 PM
thanks for the link. i hadn't realised it had been covered before. looks like any multiplicand with a nonbinary representable fraction multiplied to 65535 goes wrong. i think it's the display only tho'. so the number>string is broken.
10172007, 05:36 PM
Excel 97 yields the correct result. Interesting.
thanks, ▼
10172007, 11:07 PM
... which also displays the correct answer of 65535 (corrected per input from Pavneet) My computer at work is equipped with MS XP Professional, MS Office 2003, and MS Internet Explorer v6. Now, based upon some of my own impressions of MS Internet Explorer v7 and MS Vista (which seem to be widely shared, if internet forums are any indication)  and now this finding with MS Excel 2007, I don't want any "upgrades". BTW, you may find it quite difficult to restore MS IE v6 after installing MS IE v7. Apparently, in order to make good on the claim that IE was an integral part of the OS during the browserwar litigation of a few years ago, MS really *did* interlock the code in some fashion. I wonder if MS Excel 2007 can correctly calculate 100.0099.990.01? The older versions couldn't... Anyway, I prefer HP calculators and programs over spreadsheet software for calculations using small amounts of input data.
 KS
Edited: 18 Oct 2007, 11:20 p.m. after one or more responses were posted ▼
10182007, 08:08 AM
Just for the record, OpenOffice 2.3, which I use, returns 65,535 for both operations... But no spreadsheet is as satisfying to use as my trusty HPs. Well maybe Lotus Improv on a NeXT, but that is a whole other history ;). Cheers.
Karl, if you read this can you pop me an email at <my first name> <underscore> <my last name> at waroc.com? Many thanks. Edited: 18 Oct 2007, 8:14 a.m.
10182007, 10:55 AM
Quote: For what it's worth, OpenOffice 2.2 gets the right answer. 
Possibly Related Threads...  
Thread  Author  Replies  Views  Last Post  
Dynamic Gaussian Quadrature code in Excel VBA  Namir  4  873 
07302013, 07:37 PM Last Post: Namir 

OT: Excel regression modeling using VBA  Namir  0  442 
12062012, 10:05 AM Last Post: Namir 

OT: Excel strikes again!  Rodger Rosenbaum  6  898 
09262007, 12:11 PM Last Post: Eamonn 

HP35s / RPN Calculator Simulator in Excel / Java?  Thomas Chrapkiewicz  6  942 
08232007, 07:30 AM Last Post: Thomas Chrapkiewicz 

Error in Excel Builtin Functions (perhaps OT)  Les Wright  5  833 
07022006, 01:25 AM Last Post: Les Wright 

Loading Excel data onto HP 49g+  steve  3  672 
11042005, 07:23 PM Last Post: steve 

stat pac for Excel  Jim Kimes  8  1,017 
06102004, 11:17 AM Last Post: Jim Kims 