FUNCTION CATALOGUE / MATH & TRIGONOMETRY
MOD Excel function
Returns a remainder after division.
Correct sentence to use
Return the remainder when [number] is divided by [divisor].
Modify this query in PlainFormula →Example formula
=MOD(A2,3)
Returns the remainder after division.
Syntax
MOD(number, divisor)
Argument signature: number, divisor
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.