Microsoft KB Archive/29752

Function Mod(1.0E15,9) Gives an ERR Error Message

PSS ID Number: Q29752 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

Problem:

If you type the following in a cell in the spreadsheet, you will receive an “ERR” error message:

MOD(1E15,9)

Response:

The MOD function will return an error for mod(x,y) if abs(x) and abs(y) >= 2^27. The algorithm should be exact if an error message is not returned.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 1.05 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.