The basics
Find the remainder after dividing
=MOD(A2,B2)How it works in Excel
- A2 is the number being divided.
- B2 is what you divide by.
- The result is what is left over.
- =MOD(A2,2) gives 0 for even numbers and 1 for odd numbers.
The idea in general
Share 10 sweets among 3 people and 1 is left over.
What I assumed
- The number is in A2 and the divisor is in B2.
Check the result on your own data before relying on it.