MOD

See also A-Z Spreadsheet Function List

Description Returns the remainder after dividing a number by a specified divisor.

Syntax MOD(number, divisor)

number is any number.

divisor is any non-zero number. If divisor is 0, #DIV/0! is returned.

See Also INT , ROUND , and TRUNC functions

Examples MOD(-23, 3) returns 1

         MOD(-23, -3) returns -2