1. indirect 函数：返回对应的引用（reference），而不是值
=MAX(INDIRECT("D1:D11"))
单元格当前列自增
=MAX(INDIRECT( ADDRESS(1,COLUMN()) & ":" & ADDRESS(ROW()-1, COLUMN(),4)))+1
2. LOOKUP(A1,{0,60,70,80,90},{"不及格","及格","良好","优秀","优异"})
3.
