第1个回答 推荐于2016-01-30
=IF(OR(LEFT(A1)={"A","B","C","D"}),"海鲜",IF(OR(LEFT(A1)={"E","F","G","H"}),"冻品","") )本回答被提问者采纳
第2个回答 推荐于2016-06-18
B1格输入
=IF(OR(LEFT(A1)="A",LEFT(A1)="B",LEFT(A1)="C",LEFT(A1)="D"),"海鲜",IF(OR(LEFT(A1)="E",LEFT(A1)="F",LEFT(A1)="G",LEFT(A1)="H"),"冻品","") )
向下填充拖动
第3个回答 2012-05-28
=IF(OR(LEFT(A1)={"A","B","C","D"}),"海鲜","冻品")