MOD - Function Problem

[jasmartins]

when i apply the MOD function in a number>100000000000 returns #NUM

 

[Frank Kabel]

Hi
this is one annoying problem of Excel's MOD implementation. It can't
handle large numbers

 

[Dana DeLouis]

Here's a good kb article:

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

http://support.microsoft.com/default.aspx?scid=kb;EN-US;119083