MOD

MOD

Synopsis

MOD(number,divisor)

Description

MOD function returns the remainder when divisor is divided into number.

  • MOD returns #DIV/0! if divisor is zero.
  • This function is Excel compatible.

Examples

MOD(23,7) equals 2.

See also

CEIL, CEILING, FLOOR, ABS, INT, ABS.