Returns the remainder after number is divided by divisor. The result
has the same sign as divisor.
Syntax
MOD(number,divisor)
Number is the number for which you want to find the
remainder.
Divisor is the number by which you want to divide
number. If divisor is 0, MOD returns the #DIV/0! error value.
Examples
MOD(3,
2) equals 1
Rounds a number down to the nearest integer.
Syntax
INT(number)
Number is the real number you want to round down to an
integer.
Examples
INT(8.9)
equals 8