来自万隆君的问题
=IF(LEFT(A1,3)="AAA","DG-7",IF(LEFT(A1,3)="ABB","DG-6",IF(LEFT(A1,3)="ABC","DCF-2","")))在EXCL表中在EXCL表中上述公式如何输入,我是一个字母一个字母拼的.
=IF(LEFT(A1,3)="AAA","DG-7",IF(LEFT(A1,3)="ABB","DG-6",IF(LEFT(A1,3)="ABC","DCF-2","")))在EXCL表中
在EXCL表中上述公式如何输入,我是一个字母一个字母拼的.
1回答
2020-07-17 10:41