MOD()

MOD() divides two numbers and returns the remainder.

Use MOD() to test if two numbers divide evenly or to isolate the remainder of a division calculation.

Function Format

MOD(N1,N2)

MOD() returns the remainder left over after the second number N2 is divided into the first number N1. The remainder has the same number of decimals as the number with the larger number of decimals.

Examples

MOD(93,10) = 3

MOD(66,16.00) = 2.00

MOD(53.45,10) = 3.45

In a payroll file, to define a field that shows the number of months since the last anniversary, specify:

MOD(Months_Of_Service,12)