假设你的意思是A1单元格内容为1时是A,为2时是B,为3时是C=IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C","")))2003版可以嵌套七层IF函数或=VLOOKUP(A1,{1,"A";2,"B";3,"C"},2,)或=LOOKUP(A1,{1,2,3},{"A","B","C"})
=IF(条件1,"A",IF(条件2,"B","C"))
