如题所述
公式为：
=IF(LEFT(G2,2)="高级",200,IF(LEFT(G2,2)="中级",150,100))
如图所示：
温馨提示：答案为网友推荐，仅供参考
第1个回答 2020-03-05
在M2中输入或复制粘贴下列公式之一
=IF(LEFT(G2,2)="高级",200,IF(LEFT(G2,2)="助理",100,150))
=IF(LEFT(G2,2)="助理",100,IF(LEFT(G2,2)="高级",200,150))
=(LEFT(G2,2)="高级")*200+(LEFT(G2,2)="助理")*100+AND(LEFT(G2,2)<>{"高级","助理"})*150
=IF(LEFT(G2,2)="高级",200,IF(LEFT(G2,2)="助理",100,150))
=IF(LEFT(G2,2)="助理",100,IF(LEFT(G2,2)="高级",200,150))
=(LEFT(G2,2)="高级")*200+(LEFT(G2,2)="助理")*100+AND(LEFT(G2,2)<>{"高级","助理"})*150
