传统的九九乘法表函数:
=IF(COLUMN(A1)<=ROW(A1),ROW(A1)&"×"&COLUMN(A1)&"="&ROW(A1)*COLUMN(A1),"")
=IF(COLUMN(A:I)<=ROW(1:9),ROW(1:9)&"×"&COLUMN(A:I)&"="&ROW(1:9)*COLUMN(A:I),"")
新玩法:
=MAKEARRAY(9,9,LAMBDA(a,b,IF(a>=b,b&"×"&a&"="&a*b,"")))
好吧,工作表函数开始长出代码嘴脸了~