Hello Dears
May be somebody could tell me why I'got this error
function is =MOD(1000000000;2)
result is #NUM!
seem that MOD function does not accept numbers >= 1.000.000.000
Why ?
1.000.000.000 at least is not such a big number
If you can help I would appreciate
Thank you !
Last edited by Paolo Lavazza; 01-29-2010 at 07:59 AM.
Hi,
This is a known issue use this instead:
=1000000000-(INT(1000000000/2)*2)
=number-(INT(number/divisor)*divisor)
more info here
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
(!!!) thank you [ SOLVED ]
Will it be fixed soon or later ?
unfortunately I use a lot MOD function
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks