=MOD(value, divisor)
Examples:
=MOD(3,2)
OR
=MOD(A2,B2)
Let's say cell A2 = 3 and cell B2 = 2 as the first modulus formula above.
The answer would be a remainder of 1. As 3 divided by 2 will give a remainder of 1. That is how the formula works.
Examples:
=MOD(3,2)
OR
=MOD(A2,B2)
Let's say cell A2 = 3 and cell B2 = 2 as the first modulus formula above.
The answer would be a remainder of 1. As 3 divided by 2 will give a remainder of 1. That is how the formula works.
0 comments:
Post a Comment