Show 

Home > Function Library > Math Functions > MOD

 

MOD

 

Math Functions > MOD

Return the remainder after number is divided by divisor.

You can download the sample file (Math.cell) to practice functions.

Formula> =MOD(number,divisor)

If the divisor is set to 0, the #DIV/0! error value is returned.

Steps

  1. Select the cell in which you want the result to appear.
  2. Click the Function Wizard icon on the formula bar to open the Function Wizard dialog.
  3. Select Math from the Function Classification list and then select MOD from the Function Name list.
  4. Click the OK button on the Function Wizard dialog.
  5. Enter the number to be divided for the remainder in the Number box and the number to divide with in the Divisor box on the Function Argument dialog.
  6. Click the OK button on the Function Argument dialog.

Note

Argument Tip

If you click on each of the argument boxes of the Function Argument dialog, each of the argument descriptions appears at the bottom of the dialog.