Navigation:  Formula Reference > Spreadsheet Formula Functions >

MOD

Previous pageReturn to chapter overviewNext page

 

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

PRODUCT

QUOTIENT