Q:

# What is the Excel remainder function?

A:

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.

## Keep Learning

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

Sources:

## Related Questions

• A: Curve grades or scores in Microsoft Excel by using a simple addition formula to add a set number of points to each score. This method assumes a simple curv... Full Answer >
Filed Under:
• A: You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, ... Full Answer >
Filed Under:
• A: Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represent... Full Answer >
Filed Under:
• A: To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cell... Full Answer >
Filed Under:
PEOPLE SEARCH FOR