Multiplying two-digit numbers by 11: school method and visual demonstration in Excel

Multiplying by 11 often seems like something magical: children see a quick result, but do not always understand why it turns out that way. In fact, there is no magic here — only a simple and logical school algorithm that can be easily explained with your fingers, on paper and, what is especially convenient, in Excel

In this In this article we will look at:

• classic school method of multiplying two-digit numbers by 11 ;
• several examples — from the simplest to those where discharge transfer occurs;
• how to show this method step by step in Excel so that the result is visual and understandable;
• why this method works and how it is useful for the development of mental arithmetic.

The material is suitable for schoolchildren, parents, teachers and anyone who wants to learn to count faster and more meaningfully, writes xrust.

What is the essence of the school method of multiplying by 11

class=»notranslate»>__GTAG12__ Let's consider the simplest example:

12 × 11

The school method offers the following algorithm:

1. Take two-digit number — 12
2. Divide it into numbers: 1 and 2
3. Add these numbers:
   1 + 2 = 3
4. Insert the resulting amount between the original numbers

We get the result:

132

Let's check in the usual way:

12 × 11 = 132 ✔

It looks simple, which is why this method is so popular in elementary schools.

Why this method works

The number 11 can be represented as:

10 + 1

Then:

12 × 11 = 12 × (10 + 1) =
12 × 10 + 12 × 1 =
120 + 12 = 132

And the school method — it's just a simplified notation of this calculation , where:

• the first digit is tens,
• the last one is units,
• and the middle is the sum of digits, which precisely reflects addition.

Step-by-step analysis: example 12 × 11

Let's break it down in as much detail as possible:

This procedure is easy to automate and works great in Excel.

Some more simple examples

Example 1: 23 × 11

1. Number: 23
2. Numbers: 2 and 3
3. Amount: 2 + 3 = 5
4. Insert the amount between the numbers

Result: 253

Check:
23 × 11 = 253 ✔

Example 2: 47 × 11

1. Number: 47
2. Numbers: 4 and 7
3. Sum: 4 + 7 = 11

This is where an important point appears.

Sum of digits two-digit , so carryover needs to be taken into account.

What to do if the sum of the digits is more than 9

Let's consider in detail:

47 × 11

1. We separate the numbers: 4 and 7
2. We add: 4 + 7 = 11
3. The last digit of the amount (1) is inserted between 4 and 7
4. The first digit of the amount (1) is added to the first digit of the number

We get:

• first digit: 4 + 1 = 5
• middle: 1
• last digit: 7

Result: 517

Check:
47 × 11 = 517 ✔

More examples with transfer

class=»notranslate»>__GTAG5__ 58 × 11

1. Numbers: 5 and 8
2. Amount: 5 + 8 = 13
3. Insert 3
4. 1 is added to 5

Result: 638

Check:
58 × 11 = 638 ✔

99 × 11

1. Numbers: 9 and 9
2. Amount: 18
3. Insert 8
4. 1 add to the first 9 → 10

Result: 1089

Let's move on to Excel: why is it needed here

Excel allows:

• visualize each step ;
• show the algorithm to a child or student;
• automatically check the result;
• quickly look at dozens of examples.

This is especially convenient for training and self-testing.

Preparing a table in Excel

Let's create a simple table:

Step 1. Enter the original number

In cell A2 enter:

12

Step 2. Get the first digit

In B2 we use the formula:

=INTEGER(A2/10)

class=»notranslate»>__GTAG10__ Result: 1

Step 3. Get the second digit

In C2 :

=REMAT(A2,10)

Result: 2

Step 4. Add the numbers

In D2 :

=B2+C2

Result: 3

Step 5. Forming the result without transfer class=»notranslate»>__GTAG45__

For simple cases (when the amount is < 10) in E2 :

=B2& D2 &C2

Result: 132

How to process transfer in Excel

For a universal solution, we use the formulas:

First digit of the result

=B2+INTEGER(D2/10)

Middle digit

=RESIDENT(D2;10)

Final result formula

=(B2+INTEGER(D2/10))*100+REMAT(D2,10)*10+C2

This formula works correctly for all two-digit numbers.

Example in Excel: 47 × 11

Why this method is useful for learning

• develops understanding of the digits ;
• trains oral counting ;
• reduces fear of multiplication;
• great for primary and secondary schools;
• is easily automated in Excel.

Frequent mistakes of schoolchildren

1. They forget about the transfer if the amount > 9
2. They add the wrong numbers
3. They confuse the insertion order
4. They do not check the result with regular multiplication

Excel helps you avoid these mistakes by showing each step.

Results

The school method of multiplying two-digit numbers by 11 is:

• simple,
• logical,
• visual algorithm,
  which is easy to explain even to the child.

And Excel turns it into a interactive learning tool , where every step is transparent and understandable.

If you want to learn to count faster, explain a topic to a schoolchild, or simply systematize knowledge, this method is ideal.

Xrust Multiplying two-digit numbers by 11: school method and visual demonstration in Excel