SpreadJS Documentation
MOD
SpreadJS Documentation > Formula Reference > Formula Functions > 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

See Also