Divides one numeric expression by another numeric expression and returns the remainder.

MOD(nDividend, nDivisor)

Parameters

nDividend

Specifies the dividend. The number of decimal places in nDividend determines the number of decimal places in the return value.

nDivisor

Specifies the divisor. A positive number is returned if nDivisor is positive, and a negative number is returned if nDivisor is negative.

Return Value

Remarks

Example

	Copy Code
CLEAR ? MOD(36,10) && Displays 6 ? MOD((4*9), (90/9)) && Displays 6 ? MOD(25.250,5.0) && Displays 0.250 ? IIF(MOD(YEAR(DATE( )), 4) = 0, 'Summer Olympics this year'; , 'No Summer Olympics this year')

See Also