for those that use excel



#9

try 850*77.1 or 12850*5.1

wrong answers whoops!


#10

Excel yields 65535 as my calculator. I don't get the joke...

EDIT: Ok, that was the trusty 97. The newest Excel produces 100000. Now I get the joke ;-)


Edited: 17 Oct 2007, 3:12 p.m.

#11

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/cgi-sys/cgiwrap/hpmuseum/archv017.cgi?read=125330#125330

- Thomas


#12

thanks for the link. i hadn't realised it had been covered before. looks like any multiplicand with a non-binary representable fraction multiplied to 65535 goes wrong. i think it's the display only tho'. so the number->string is broken.

#13

Excel 97 yields the correct result. Interesting.

thanks,
bruce


#14

... 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 browser-war 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.00-99.99-0.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


#15

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 e-mail at <my first name> <underscore> <my last name> at waroc.com? Many thanks.


Edited: 18 Oct 2007, 8:14 a.m.

#16

Quote:
I wonder if MS Excel 2007 can correctly calculate 100.00-99.99-0.01? The older versions couldn't...

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 399 07-30-2013, 07:37 PM
Last Post: Namir
  OT: Excel regression modeling using VBA Namir 0 167 12-06-2012, 10:05 AM
Last Post: Namir
  OT: Excel strikes again! Rodger Rosenbaum 6 364 09-26-2007, 12:11 PM
Last Post: Eamonn
  HP35s / RPN Calculator Simulator in Excel / Java? Thomas Chrapkiewicz 6 359 08-23-2007, 07:30 AM
Last Post: Thomas Chrapkiewicz
  Error in Excel Built-in Functions (perhaps OT) Les Wright 5 342 07-02-2006, 01:25 AM
Last Post: Les Wright
  Loading Excel data onto HP 49g+ steve 3 307 11-04-2005, 07:23 PM
Last Post: steve
  stat pac for Excel Jim Kimes 8 478 06-10-2004, 11:17 AM
Last Post: Jim Kims

Forum Jump: