Translations:Documentation/Calc Functions/MOD/18/en

    From The Document Foundation Wiki
    Formula Description Returns
    =MOD(11;2) Remainder of 11/2 1
    =MOD(-11;2) Remainder of -11/2. The sign is the same as divisor. 1
    =MOD(11;-2) Remainder of 11/-2. The sign is the same as divisor. -1
    =MOD(11;-2) Remainder of 11/-2. The sign is the same as divisor. -1
    =MOD(-11;-2) Remainder of -11/-2. The sign is the same as divisor. -1
    =MOD(11.25;2.5) Remainder of 11.25/2.5 1.25
    =MOD(11;0) function returns an error value since Divisor is 0 1.25