This time, I want to set a challenge which is not difficult and useful for your kids.
The challenge is to write a formula which can be dragged right and down to generate a multiplication table.
The solution to this challenge will be published after a month i.e. on 1-May-17.
Some not so usual methods:
1) Select A1:J10 and enter the array formula: =MMULT(ROW(1:10),TRANSPOSE(ROW(1:10)))
2) Define x = COLUMN($A:$J) and y =ROW($1:$10). Now select A1:J10 and enter the array formula =x*y
3) Select A1:J10 and enter the array formula =(x-1)*y+y
4) Select A1:J10 and enter the array formula =(y-1)*x+x
Sub Multiplication()
For i = 2 To 10
For j = 1 To 10
X = Cells(1, j).Value
Cells(i, j).Value = Cells(j).Value & " X " & Cells(i).Value & " = " & (i * X)
Next j
Next i
End Sub
This is the formula
=B$1*$A2
1) Go to the raw number 2 in cell number 2 which have (4)
2) click on it and write this formula =B$1*$A2