Limit to MOD function

[jan120253]

I have discovered that the MOD funcktion apparently does not work for numbers larger than 268,435,455, as larger numbers return #NUM!. I do not seem to be able to find any documentation for this.

Can anybody help? Is there such a limitation, and is it documentet?

Jan

 

[Claus Busch]

Hi Jan,

Am Sat, 23 Feb 2013 02:22:56 -0800 (PST) schrieb (e-mail address removed):

I have discovered that the MOD funcktion apparently does not work for numbers larger than 268,435,455, as larger numbers return #NUM!. I do not seem to be able to find any documentation for this.

Can anybody help? Is there such a limitation, and is it documentet?

I tested it and you are right. With larger number I get the error. But I
also can't find any documentation about this error. You can do a
workaround:
MOD(n, d) = n - d*INT(n/d)


Regards
Claus Busch

 

[jan120253]

Thank you. I used the workaround and I also found an explanation:

http://excel.tips.net/T003302_Large_Numbers_in_the_MOD_Function.html

Jan