Returns the remainder of a division operation.

Syntax

@Modulo( number1 ; number2 )

Parameters

number1

Number or number list.

Number or number list. If this is equal to 0, @Modulo returns @ERROR.

remainder

Number or number list. The remainder of number1 divided by number2. If the parameters are number lists, @Modulo returns a list that is the result of pair-wise computation on the list values. The sign of the result is always the same as the sign of the number1.

A common use of @Modulo is to determine whether a number is odd or even; if the result of @Modulo(number;2) is 1, the number is odd; if the result is 0, the number is even.

When using this function with a number list, the list concatenation operator takes precedence over any other operators; negative numbers must be enclosed in parentheses.

Language cross-reference

Mod operator of LotusScript language

Example
See Also

List concatenation operator
Performing arithmetic operations

Glossary