Excel two-step production "multiplication table"

A colleague recently asked me to create a “Nine-Nine-Multiplication Table” for him. It sounds simple, but it can be cumbersome if you type it manually. But with Excel, we can quickly create a multiplication table (shown in Figure 1). The steps are as follows:

Step 1: Start Excel 2000, merge the cells A1-J1, and then enter the title "Multiplication Table" and set to “Center” Enter 1-9 in B2-J2 and 1-9 in A3-A11. It can be entered by dragging the mouse.

Step 2: In cell B3, enter: “=IF(AND($A3<〉"",B$2<〉"",B$2<=$A3), $A3&&"×"&&B$2&&"="&&$A3*B$2,"")” (shown in Figure 2) After the completion of the carriage return, you can automatically enter 1× 1=1; drag the cross from cell B1 to cell B11, and then drag the cell to J11, which will automatically generate a triangle multiplication table.

how? Very convenient! If you need it, you can use this method to make a multi-digit multiplication table.