=IF(or(left(R15,4)="75.0",left(r15,4)="75.1",left(r15,4)="75.2","外购半成品",IF(OR(left(R15,2)="80",left(R15,2)="81"),"圆柱电池",IF(OR(left(R15,4)="80.1",lefr(R15,4)="81.1"),"方形软包",IF(left(R15,4)="80.3","圆柱软包","原材料")))) 请问这个公式哪里错了呢？_Excel

问题已解决

=IF(or(left(R15,4)="75.0",left(r15,4)="75.1",left(r15,4)="75.2","外购半成品",IF(OR(left(R15,2)="80",left(R15,2)="81"),"圆柱电池",IF(OR(left(R15,4)="80.1",lefr(R15,4)="81.1"),"方形软包",IF(left(R15,4)="80.3","圆柱软包","原材料")))) 请问这个公式哪里错了呢？

84785034| 提问时间：2021 10/15 15:10

使用APP提问，老师回复第一时间提醒，下载APP>

温馨提示：如果以上题目与您遇到的情况不符，可直接提问，随时问随时答

速问速答

家权老师

金牌答疑老师

职称：税务师

免费直播

=IF(OR(LEFT(R15,4)=75.0,LEFT(R15,4)=75.1,LEFT(R15,4)=75.2),外购半成品,IF(OR(LEFT(R15,2)=80,LEFT(R15,2)=81),圆柱电池,IF(OR(LEFT(R15,4)=80.1,LEFT(R15,4)=81.1),方形软包,IF(LEFT(R15,4)=80.3,圆柱软包,原材料))))

2021 10/15 20:48