A simple multi-skills test

Excellent Excel
Excellent Excel
考考各位看官的猜想、推理、数学、EXCEL能力:

新建一份EXCEL表格(Google Spreadsheet 也行),在 A1:I9 的每个单元格内输入以下公式——

=IF(COLUMN()>ROW(),"",VLOOKUP(COLUMN(),$L$1:$M$9,2)&VLOOKUP(ROW(),$L$1:$M$9,2)&IF(COLUMN()*ROW()<10,"得","")&IF(COLUMN()*ROW()<10,VLOOKUP(COLUMN()*ROW(),$L$1:$M$9,2),VLOOKUP(INT(COLUMN()*ROW()/10),$L$1:$M$9,2)&"十"&VLOOKUP(MOD(COLUMN()*ROW(),10),$L$1:$M$10,2,FALSE)))

请问,应该在表格的什么地方填入什么预设值,才能让 A1:I9 的内容变得有意义?

提示:有 20 个单元格需要预设值。

Related Posts

Leave a comment

Your email address will not be published. Required fields are marked *