Forum Discussion
Likinfl
Feb 15, 2020Copper Contributor
issue with mod function. =MOD(638.52,53.21) returns 53.21 instead of 0
=MOD(638.52,53.21) returns 53.21 instead of 0. I have Office 365, version 2001, Build 12430.20184. Thanks for your help
SergeiBaklan
Feb 15, 2020Diamond Contributor
That's rounding error. In general it's better to keep divider as integer for MOD()
=MOD(63852,5321)