IF(OFFSET(INDIRECT(SUBSTITUTE(ADDRESS(1,COLUMN(),4),1,)&TEXT(ROW(),"@")),-1,0)="c","√","×")
1、获得当前单元格的字母
ADDRESS(1,COLUMN(),4),1,)
2、将字母转换为单元格引用
INDIRECT()
3、单元格偏移
OFFSET(起始单元格,)
IF(OFFSET(INDIRECT(SUBSTITUTE(ADDRESS(1,COLUMN(),4),1,)&TEXT(ROW(),"@")),-1,0)="c","√","×")
1、获得当前单元格的字母
ADDRESS(1,COLUMN(),4),1,)
2、将字母转换为单元格引用
INDIRECT()
3、单元格偏移
OFFSET(起始单元格,)