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.
The MOD function has the following format:
MOD(int_1, int_2)
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.
The MOD function returns a number.
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 |