Microsoft KB Archive/62519

{|
 * width="100%"|

Excel: MOD Function Returning a #NUM! Error

 * }

-

The information in this article applies to:


 * 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 :

Technology :