MOD
The number of digits should not be a problem. Excel supports up to 15
digits of precision and it will accept longer representations even if
it truncates their precision to 15 digits.
On the other hand, using a number literal as formatted (i.e. with the
commas as thousand separator) WILL cause an error because commas are
confused with the argument separator.
Try entering the number in a different cell (say A1) and then using
=MOD(A1,something). You should not get an error.
HTH
Kostis Vezerides
J.H. wrote:
I have a question on the funtion "MOD". When the number to be divided is more
than nine digits (like: 1,234,457,890), the funtion would return error. How
can I fix this?
Thanks.
|