Hi
send an email to


but fortunately (as also mentioned in the help) there's a workaround
using INT

--
Regards
Frank Kabel
Frankfurt, Germany

"Gold Fish" <Gold schrieb im
Newsbeitrag ...
Excel is not able to make computations using the MOD function of
numbers as
large as 10 billion. So for example if we type in
=MOD(10000000000,10)
We get a result of
#NUM!
This is something I can do in my head, or my calculator, it is
disappointing
that excel can't handle it. This is a suggestion and not a bug,
because the
MOD function works fine, its just that someone didnt have the
foresight to
allow it to work for large values. I am guessing that the solution
to this
will only require changing a single line of code.