EXCEL中大于0小于等于1输出A;大于1小于等于2输出B；大于2小于等于3输出C；一直到输出H，请问怎么实现

Answer 1

=LOOKUP(CEILING(A1,1),{1,2,3,4,5,6,7,8},{"A","B","C","D","E","F","G","H"})

Answer 2

数值在A1
B1输入公式 =IF(A1>0,CHAR(64+CEILING(A1,1)),"")
就可以了