Limit to MOD function

  • Thread starter Thread starter jan120253
  • Start date Start date
J

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
 
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?
Click to expand...

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
 
Back
Top