Odd, even and remainders with MOD
1 / 5
People are split into teams. How many are left over once every full team is made?
keyboard Typing formulas is easiest on a computer with a keyboard.
A1
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Event | People | Team size | Left over | |
| 2 | Bake-off | 33 | 6 | ||
| 3 | Hackathon | 13 | 3 | ||
| 4 | Pub quiz | 15 | 3 | ||
| 5 | Escape room | 14 | 3 | ||
| 6 | Debate club | 13 | 4 | ||
| 7 | Charity walk | 27 | 4 | ||
| 8 | Relay race | 14 | 4 | ||
| 9 | |||||
| 10 | |||||
| 11 | |||||
| 12 |
people
team size
left over
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
How MOD and ISEVEN and ISODD works
What does
MODdo?MODgives the remainder after dividing:=MOD(17,5)is 2, because 5 goes into 17 three times with 2 left over.How do you spot even and odd numbers?
A number is even when
MOD(A2,2)is 0.ISEVENandISODDask the same question and answerTRUEorFALSE:=ISEVEN(A2).Where is
MODuseful?Leftovers after making teams or packs, and the spare days after whole weeks:
=MOD(B2,7).
Know someone fighting with a spreadsheet? Send them this page.