Excel中想实现如果一个单元格中的文本，属于XX或XX或XX，那么就在新的单元格中显示相应文本

显示全部楼层 · 2013-10-23 16:24:45

请用公式：=IF(ISERR(FIND(A1,"大号小号中号")),"无型号","有型号")...

千问 · 2013-10-23 16:24:45

公式为:=IF(OR(A1={"大号","小号","中号"}),"有型号","没型号") 或:=IF((A1="大号")+(A1="小号")+(A1="中号"),"有型号","没型号")...

千问 · 2013-10-23 16:24:45

B1=IF(A1="","没型号","有型号")或=IF(A1"","有型号","没型号")下拉填充...