MOD

Definition of MOD

Returns the result of the modulo operator, the remainder after a division operation.

Sample Usage

MOD(10,4)

MOD(A2,B2)

Syntax

MOD(dividend, divisor)

  • dividend - The number to be divided to find the remainder.

  • divisor - The number to divide by.

 

In order to use the MOD formula, start with your edited Excellentable:

Screen Shot 2016-06-30 at 3.50.40 PM.png

Then type in the MOD Formula in the area you would like to display the outcome:

Screen Shot 2016-06-30 at 3.50.51 PM.png

By adding the values you would like to calculate the MOD formula for, Excellentable will generate the outcome:

Screen Shot 2016-06-30 at 3.50.59 PM.png

There were errors rendering macro:

  • An unknown error occurred.