MOD(number, divisor) 
Returns the remainder after division. 
number  The number for which you want to find the remainder of. 
divisor  The number you want to divide by. 
Remarks 
* The result of this function is the remainder when "number" is divided by "divisor". * The result of this function has the same sign as the sign of the "divisor". * If "divisor" = 0, then #DIV/0! is returned. * If "number" < "divisor", then "number" is returned. * If "number" is exactly divisible by "divisor", then 0 is returned. * This function can be expressed in terms of the INT function: MOD(n, d) = n  (INT(n/d)*d). * The equivalent VBA function is the MOD Operator * The Excel calculation is different to the VBA calculation so you can get different answers. * In Excel 2010 the accuracy of this function was improved. * For the Microsoft documentation refer to support.office.com 

1  What is the remainder when you divide 3 by 2. 2  What is the remainder when you divide 3 by 2. 3  What is the remainder when you divide 3 by 2. 4  What is the remainder when you divide 3 by 2. 5  What is the remainder when you divide 6  What is the remainder when you divide 7  What is the remainder when you divide 8  What is the remainder when you divide 9  What is the remainder when you divide 10  What is the remainder when you divide 11  What is the remainder when you divide 12  What is the remainder when you divide 13  What is the remainder when you divide 14  What is the remainder when you divide 15  What is the remainder when you divide 16  What is the remainder when you divide 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top