XL: MOD() Function Returns #NUM! Error Value

For a Microsoft Excel 2001 or Microsoft Excel 98 version of this article, see 119083 .


The MOD() function in Microsoft Excel may return a #NUM! error value instead of a valid remainder (modulus).


The MOD() function returns the #NUM! error if the following condition is true:

('divisor' * 134217728) is less than or equal to 'number'


If the above condition is true, and the MOD() function returns a #NUM! error, you can use the following formula to calculate the remainder (modulus) of two numbers:

For example, instead of using this formula

use this formula:


More Information

In Microsoft Excel, the MOD() function returns the remainder (modulus) of dividing one number by another. The MOD() function accepts two arguments:

Argument Definition
Number The number being divided
Divisor The number being divided by
If you want to calculate the remainder (modulus) of 22 divided by 5, you would use the following formula:
The result is 2 (22 divided by 5 leaves a remainder of 2).

If the divisor argument, multiplied by 134,217,728 (or 2 raised to the 27th power), is less than or equal to the number argument, the MOD() function returns a #NUM! error value.


Artikel-id: 119083 - Laatst bijgewerkt: 18 jan. 2007 - Revisie: 1