开头字符开头的话反馈某个值，怎么设公式？

象山海鲜 · 发表于 2024-3-6 10:48

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

复制代码

天有多高999 · 发表于 2024-3-6 10:49

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

天有多高999 · 发表于 2024-3-6 10:52

回复还在审核中

永中冯少 · 发表于 2024-3-6 10:57

天有多高999 发表于 2024-3-6 10:47
有文件吗，发个我试下。。。

主题里面刚上传了

菜狗一只 · 发表于 2024-3-6 11:07

复制代码

boyuanoffice · 发表于 2024-3-6 11:30

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

复制代码

或

复制代码

天有多高999 · 发表于 2024-3-6 11:43

用ieft取单元格前4位，后面去掉通配符

朝露孤烟 · 发表于 2024-3-6 13:03

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

朝露孤烟 · 发表于 2024-3-6 13:04

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

朝露孤烟 · 发表于 2024-3-6 13:06

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

		自动登录	找回密码
密码			免费注册

[求助] 开头字符开头的话反馈某个值，怎么设公式？