View Single Post
  #18  
Old October 8th, 2003, 01:01 PM
Jerry W. Lewis
external usenet poster
 
Posts: n/a
Default Bug in Excel's (not VBA's) MOD function

The free .xls editor from
http://www.byedesign.freeserve.co.uk/
also gets it right.

Jerry

Harlan Grove wrote:

"Harlan Grove" wrote...

"Harlan Grove" wrote...
...

For instance, MOD(12345678000,64) returns #NUM! . . .

...

FWIW, the Works 2000 (ver 5) spreadsheet also returns an error, but
OpenOffice Calc 1.0 returns 48 as expected. While I haven't tested this
under other spreadsheets (yet), I think it's safe to say this, er,
functionality is unique to Microsoft.


And FWIW, Lotus 123 releases 5 and 9.7, Quattro Pro 10 and OpenOffice Calc 1.1
all give the correct/expected result of 48. I'm not going to bother testing
various windows shareware/freeware or Linux spreadsheets.