Excel: MOD Function Returning a #NUM! Error

• Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0
• Microsoft Excel for Windows, version 4.0

SUMMARY

There is a limitation in the Microsoft Excel MOD function. If the result of the division is greater than (2^27)-1 or 134,217,728, the MOD function will return #NUM!.

To determine the result of the division, in a separate cell, perform the operation =Number/Divisor_Number. If this result is larger than 134,217,728, then the MOD function will return a #NUM!.

This is a limitation of Microsoft Excel.

Use the following formula for operations if the result of the division is greater than 134,217,728:

   =Number-(INT(Number/Divisor)*Divisor). 

Additional query words: 2.20 2.21 3.0 limit limitation

Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 21, 1999