Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Jerry W. Lewis wrote...
And I cannot reproduce #2 (even after correcting for formatting problems) =MOD(987654321098765*8+1,543210987654321) returns the correct answer, despite a 16-digit first argument. .... OK, but the main point should be that Excel doesn't use IEEE 64-bit modulus. In hardware terms, Excel's MOD is (unfortunately) more than just a simple wrapper around the Wintel FPU's FPREM1 operation. Yes, that's right folks, Excel screws up some arithmetic operations, and while it may or may not have been intentional, it may be inferred from http://support.microsoft.com/default...b;en-us;119083 that Microsoft has no immediate plans to fix it. what a company! [In case anyone needs a lesson in why lack of competition is a BAD THING . . .] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel's Fourier Analysis should be a function, so that results upd | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |