• Mathematical and Financial Functions
  • Mathematical and Financial Functions
  • ABS function
  • AVERAGE function
  • CGROUP function
  • CGROUPT function
  • COLCOUNT function
  • COUNTIF function
  • EXP function
  • FV function
  • LOG function
  • MAX function
  • MEDIAN function
  • MIN function
  • MKDEC function
  • MKINT function
  • MOD function
  • POS function
  • PV function
  • R function
  • RATIO function
  • RC function
  • RCNV function
  • RCR function
  • RCTOTAL function
  • ROUND function
  • ROWCOUNT function
  • RR function
  • RRTOTAL function
  • STDDEV function
  • SUM function
  • TOTAL function

MOD Function

The MOD function calculates the remainder when one number, the numerator, is divided by another, the divisor.

Syntax

MOD(numerator,divisor)

Example 1

MOD(11,2)

Returns the value 1, which is the remainder of 11/2.

Example 2

MOD(-13,5)

Returns the value -3, which is the remainder of -13/5.

Related Topics

• Mathematical and Financial Functions