• ABS Function
• AVERAGE Function
• CGROUP Function
• CGROUPT Function
• COLCOUNT Function
• COUNTIF function
• EXP Function
• FV Function
• LOG Function
• Mathematical and Financial Functions
• 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