=LOOKUP(CEILING(A1,1),{1,2,3,4,5,6,7,8},{"A","B","C","D","E","F","G","H"})
数值在A1 B1输入公式 =IF(A1>0,CHAR(64+CEILING(A1,1)),"")就可以了
