请问第四步里用截取函数,做出来结果是“法律1班”之类的,要怎么才能改成“法律一班”
Fx=IF(MID(B3,3,2)="01","法律一班",IF(MID(B3,3,2)="02","法律二班",IF(MID(B3,3,2)="03","法律三班","法律四班")))
满意请采纳哦,么么哒