Using the Excel MOD Function
SummaryThe Excel MOD function returns the remainder after a given number is divided by the divisor. The output will have the same sign as the divisor.
Syntax=MOD (number, divisor)
The number argument is required and is the number for which you would like to find the remainder.
Divisor is also required and is the number by which you would like to divide.