Excel MOD Function
Summary
The Excel MOD function returns the remainder of two numbers after pision. For example, MOD(10,3) = 1. The result of MOD carries the same sign as the pisor.
Purpose
Get the remainder from pision
Return value
The remainder
Syntax
=MOD (number, pisor)
Arguments
- number - The number to be pided.
- pisor - The number to pide with.
Usage notes
Use the MOD function to get a reminder after pision. For Example, MOD(3,2) returns 1, because 2 goes into 3 once, with a remainder of 1.
Notes:
- MOD is often seen in formulas that need to process "every nth" value
- MOD always returns a result in the same sign as the pisor.
- MOD will return a #DIV/0! error if the pisor