What Is the Excel Remainder Function?
Last Updated Mar 25, 2020 10:10:07 AM ET
The formula to find the remainder when dividing one number by another in Microsoft Excel is =MOD(first number, second number). For example, =MOD(17,3) returns an answer of two.
The remainder is the amount left over after division. When dividing 17 by three, the decimal answer is 5.67. Therefore, three goes into 17 five times; 3 x 5 = 15, and 17 - 15 = 2, the remainder. In Excel, one could arrive at the same result using the INT function, with =17-(3*INT(17/3)). As with all Excel formulas, cell references can be used in place of numbers; if the value 17 is in A1 and 3 is in C4, the remainder can be calculated with =MOD(A1,C4).
More From Reference
What Is an Ex-Dividend Date, and How Does It Affect Your Stocks?
What Is the Difference Between Salary and Wages?
How Many Minutes of Daylight Do We Gain Each Day? And Other Daylight Saving Time Facts
Understanding SSI: Supplemental Security Income Basics for New Applicants
What Can the History of Polio Teach Us About the Coronavirus Pandemic?
How to Use a Personal Loan Calculator