Spread Formula Reference
Formula Functions / Functions M to Q / MOD
In This Topic
    MOD
    In This Topic

    This function returns the remainder of a division operation.

    Syntax

    MOD(dividend,divisor)

    Arguments

    This function has these arguments:

    Argument Description
    dividend Number for which you want to find the remainder by dividing the divisor into it
    divisor Number by which you want to divide the dividend argument

    Remarks

    The remainder has the same sign as the divisor.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    MOD(B3,10)

    MOD(C4,B2)

    MOD(R1C2,12)

    MOD(255,16) gives the result 15

    MOD(-3,2) gives the result 1

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    PRODUCT | QUOTIENT | Math and Trigonometry Functions