OpenOffice3.org Calc 3. Mathematical Functions
MOD(Dividend; Divisor) Function
Calculates the division of the given
numbers as arguments and returns the remainder or residue of the division. The
argument “Dividend” contains a numeric value or a reference to a cell containing
the dividend. The argument “Divisor” has a numeric value or a reference to a
cell containing the divisor. If the function returns 0, indicating that the
division is exact. For example:
=MOD(10;2) Returns 0. The division is exact.
=MOD(10;7) Returns 3.
=MOD(4;0) Returns the error code #VALUE!.