You're reading: Posts Tagged: spreadsheets

Mobile Numbers: Products of Twin Primes

In this series of posts, Katie investigates simple mathematical concepts using the Google Sheets spreadsheet app on her phone. If you have a simple maths trick, pattern or concept you’d like to see illustrated in this series, please get in touch.

Having spoken at the MathsJam annual conference in November 2016 about my previous phone spreadsheet on multiples of nine, I was contacted by a member of the audience with another interesting number fact they’d used a phone spreadsheet to investigate: my use of =MID() to pick out individual digits had inspired them, and I thought I’d share it here in another of these columns (LOL spreadsheet jokes).

Mobile Numbers: Multiples of nine

In this series of posts, Katie investigates simple mathematical concepts using the Google Sheets spreadsheet app on her phone. If you have a simple maths trick, pattern or concept you’d like to see illustrated in this series, please get in touch.

We’re all (hopefully) aware that a pleasing property of numbers that are divisible by nine is that the sum of their digits is also divisible by nine.

It’s actually more well known that this works with multiples of three, and an even more pleasing fact is that the reason three and nine work is because nine is one less than the number base (10), and anything that’s a factor of this will also work – so, in base 13, this should work for multiples of 12, 6, 4, 3 and 2. Proving this is a bit of fun.

Once when I was thinking about this fact, an interesting secondary question occurred.