Thread
:
Limit to MOD function
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Limit to MOD function
Hi Jan,
Am Sat, 23 Feb 2013 02:22:56 -0800 (PST) schrieb
:
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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch