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:
Then type in the MOD Formula in the area you would like to display the outcome:
By adding the values you would like to calculate the MOD formula for, Excellentable will generate the outcome:
A
|
B
|
C
|
D
|
|
|---|---|---|---|---|
1
|
||||
2
|
||||
3
|
||||
4
|
||||
5
|
||||
6
|
||||
7
|
||||
8
|
||||
9
|
||||
10
|
||||
11
|
||||
12
|
||||
13
|
||||
14
|
||||
15
|
E
|
F
|
|
|---|---|---|
1
|
2
1,775 (4,597)
7
3
94,743 (245,383)
1
4
396 (1,026)
9
5
1,143 (2,960)
4
6
7,916 (20,502)
53
7
452 (1,171)
7
8
701 (1,816)
5
9
540 (1,399)
1
10
12,133 (31,424)
27
11
1,912 (4,950)
14
12
4,509 (11,678)
2
13
926 (2,398)
2
14
15
6