What is the Excel remainder function?

By Forinfos - 02/08/2025 - 0 comments

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).

Login to Comment

Comments

Be the first to write a comment for this article.

Related Articles

What is a function in Microsoft Excel? What is the function of the cerebral cortex? What is the function of the corneal reflex? How does the NPV function in Excel work? What is the exponential parent function? What is the function of sclerenchyma cells? What is the weighted average function in Excel used for? What are some of the functions of an online Excel spreadsheet? How do you use the less than or equal to function in Excel? What function do you use to list dates in Excel?

Trending Articles

How can you attach speakers to a television? How do you draw a cross? How long was Anne Frank in hiding? How do you legally watch "Gold Rush" online? How do you upload a file to SoundCloud? How tall is Noel Paul Stookey? How can you locate a used book disposal? How do you draw an airplane? How do you find out if Netflix is having problems? How do you find a calendar of events in Kansas City?