MacXL: MOD() Function Returns #NUM! Error Value (299504)
The information in this article applies to:
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q299504 For a Microsoft Excel for Windows version of this article, see 119083.
SYMPTOMS
The MOD() function in Microsoft Excel may return a #NUM! error value
instead of a valid remainder (modulus).
CAUSE
The MOD() function returns the #NUM! error if the following condition is true:
('divisor' * 134217728) is less than or equal to 'number'
WORKAROUND
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:
=number-(INT(number/divisor)*divisor)
For example, instead of using this formula
use this formula:
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kbprb KB299504 |
---|
|