HP Forums
for those that use excel - Printable Version

+- HP Forums (https://archived.hpcalc.org/museumforum)
+-- Forum: HP Museum Forums (https://archived.hpcalc.org/museumforum/forum-1.html)
+--- Forum: Old HP Forum Archives (https://archived.hpcalc.org/museumforum/forum-2.html)
+--- Thread: for those that use excel (/thread-126831.html)



for those that use excel - hugh steers - 10-17-2007

try 850*77.1 or 12850*5.1

wrong answers whoops!


Re: for those that use excel - Meenzer - 10-17-2007

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.


Re: for those that use excel - Thomas Okken - 10-17-2007

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


Re: for those that use excel - hugh steers - 10-17-2007

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.




Re: for those that use excel - Bruce Bergman - 10-17-2007

Excel 97 yields the correct result. Interesting.

thanks,
bruce


As does MS Excel 2003.. (short MS rant) - Karl Schneider - 10-17-2007

... 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


Re: As does MS Excel 2003.. (short MS rant) - Pavneet Arora - 10-18-2007

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.


Re: As does MS Excel 2003.. (short MS rant) - Thomas Okken - 10-18-2007

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.