Previous Topic: MINUTE Function--Return the Minutes Component for a Date

Next Topic: MONTH Function--Return the Month Component of a Date

MOD Function--Return Division Remainder

The MOD function returns the modulus (remainder) of the division of the first number by the second. If the second number is zero, zero is returned.

Syntax

The MOD function has the following format:

MOD(int_1, int_2) 

Parameters

The MOD function accepts the following parameters:

int_1 (number)

The dividend of the division operation.

int_2 (number)

The divisor of the division operation.

Return Value

The MOD function returns a number.

Example

Return_value=MOD(3, 2)
Return_value=1

Return_value=MOD(6, 3)
Return_value =0


Copyright © 2010 CA. All rights reserved. Email CA about this topic