Spread Formula Reference
MOD
Formula Functions > Functions M to Q > MOD

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