The MOD function can be used to divide numbers in Excel.
Unlike regular division, however, the MOD function only gives you the remainder as an answer.
The syntax for the MOD function is:
= MOD ( Number , Divisor )
Example: Using Excel's MOD Function
For help with this example, see the image above.
- Enter the following data into the cells indicated:
D1: 5
D2: 2 - Click on cell E1 - the location where the results will be displayed.
- Click on the Formulas tab of the ribbon.
- Choose Math & Trig from the ribbon to open the function drop down list.
- Click on MOD in the list to bring up the function's dialog box.
- In the dialog box, click on the Number line.
- Click on cell D1 on the spreadsheet.
- In the dialog box, click on the Divisor line.
- Click on cell D2 on the spreadsheet.
- Click OK in the dialog box.
- The answer 1 should appear in cell E1 since 5 / 2 leaves a remainder of 1.
- When you click on cell E1 the complete function = MOD ( D1 , D2 ) appears in the formula bar above the worksheet.
Since the MOD function only returns the remainder, the integer portion of the division operation (2) is not displayed.
To show the integer as part of the answer, you can use the QUOTIENT function.
Related Tutorials
