其实按本题意,公式中不必用"○",可用"0"取代:
1).大九九口诀公式:
=IF(OR(ROW()>9,COLUMN()>9),"",NUMBERSTRING(COLUMN()&ROW(),3)&TEXT(ROW()*COLUMN(),"[>9][dbnum1];[dbnum1]00"))
2).小九九口诀公式:
=IF(OR(ROW()>9,COLUMN()>ROW()),"",NUMBERSTRING(COLUMN()&ROW(),3)&TEXT(ROW()*COLUMN(),"[>9][dbnum1];[dbnum1]00"))
按平时习惯,公式中必须用"得":
1).大九九口诀公式:
=IF(OR(ROW()>9,COLUMN()>9),"",NUMBERSTRING(COLUMN()&ROW(),3)&TEXT(ROW()*COLUMN(),"[>9][dbnum1];得[dbnum1]0"))
2).小九九口诀公式:
=IF(OR(ROW()>9,COLUMN()>ROW()),"",NUMBERSTRING(COLUMN()&ROW(),3)&TEXT(ROW()*COLUMN(),"[>9][dbnum1];得[dbnum1]0"))
上述公式,大九九:108个字符;小九九:112个字符