这个公式怎么设置啊

永中冯少

=IF(E2="1001&*","现金",IF(E2=“1002”,"银行存款",IF(E2=“1121*”,“承兑汇票”,“无”)))

当E2单元格文字是1001开头的显示现金，1002开头的显示是银行存款，1121开头的显示承兑汇票，以上都没有的显示无，这个公式哪里错误？请大佬看下。谢谢

晨光晞微

1. =IFNA(LOOKUP(1,0/(--LEFT(E2,4)={1001,1002,1121}),{"现金","银行存款","承兑汇票"}),"无")

复制代码

蓝色字体

=IF(COUNTIF(E2,"1001*")=1,"现金",IF(COUNTIF(E2,"1002*")=1,"银行存款",IF(COUNTIF(E2,"1121*")=1,"承兑汇票","无")))
这样？

卫壮壮

=IFERROR(IFS(E2=1121,"承兑汇票",E2=1002,"银行存款",E2=1001,"现金"),"无")

良良

E列是数值或是文本：
F2=IFERROR(VLOOKUP(LEFT(E2,4),{"1001","现金";"1002","银行存款";"1121","承兑汇票"},2,),"无")
或
G2=IF(LEFT(E2,4)="1001","现金",IF(LEFT(E2,4)="1002","银行存款",IF(E2="1121","承兑汇票","无")))

朝露孤烟

1.引号错了，只能用英文引号。2.条件表达错了。查找字符串少于被查找字符串时，要用函数find，search,或用函数countif来处理。

IE_Crayon

E2="1001&*"不是判断语句，Excel读不懂，要用文本函数处理；

简单的多条件判断可以用Switch和Choose，不用嵌套。

=IFNA(CHOOSE(MATCH(LEFT(B2,4),{"1001","1002","1121"},0),"现金","银行存款","承兑汇票"),"无")