Forum Discussion

Likinfl's avatar
Likinfl
Copper Contributor
Feb 15, 2020

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

Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 15, 2020

    Likinfl 

    That's rounding error. In general it's better to keep divider as integer for MOD()

    =MOD(63852,5321)

Resources