try 850*77.1 or 12850*5.1
wrong answers whoops!
The following warnings occurred: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Warning [2] Undefined array key 126831 - Line: 275 - File: inc/plugins/threaded_mode.php PHP 8.1.2-1ubuntu2.14 (Linux)
|
for those that use excel
|
|
« Next Oldest | Next Newest »
|
▼
10-17-2007, 02:54 PM
try 850*77.1 or 12850*5.1 wrong answers whoops! ▼
10-17-2007, 03:08 PM
Excel yields 65535 as my calculator. I don't get the joke... Edited: 17 Oct 2007, 3:12 p.m.
10-17-2007, 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/cgi-sys/cgiwrap/hpmuseum/archv017.cgi?read=125330#125330 - Thomas ▼
10-17-2007, 05:33 PM
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.
10-17-2007, 05:36 PM
Excel 97 yields the correct result. Interesting.
thanks, ▼
10-17-2007, 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 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 ▼
10-18-2007, 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 e-mail at <my first name> <underscore> <my last name> at waroc.com? Many thanks. Edited: 18 Oct 2007, 8:14 a.m.
10-18-2007, 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 | 1,696 |
07-30-2013, 07:37 PM Last Post: Namir |
|
OT: Excel regression modeling using VBA | Namir | 0 | 846 |
12-06-2012, 10:05 AM Last Post: Namir |
|
OT: Excel strikes again! | Rodger Rosenbaum | 6 | 1,713 |
09-26-2007, 12:11 PM Last Post: Eamonn |
|
HP35s / RPN Calculator Simulator in Excel / Java? | Thomas Chrapkiewicz | 6 | 1,827 |
08-23-2007, 07:30 AM Last Post: Thomas Chrapkiewicz |
|
Error in Excel Built-in Functions (perhaps OT) | Les Wright | 5 | 1,798 |
07-02-2006, 01:25 AM Last Post: Les Wright |
|
Loading Excel data onto HP 49g+ | steve | 3 | 1,223 |
11-04-2005, 07:23 PM Last Post: steve |
|
stat pac for Excel | Jim Kimes | 8 | 1,945 |
06-10-2004, 11:17 AM Last Post: Jim Kims |