excel第一套第四问怎么做
fx=IF(MID(A2,3,2)="01","1班",IF(MID(A2,3,2)="02","2班","3班"))
需要将if和mid函数结合起来
=IF(MID(A2,3,2)="01","1班",IF(MID(A2,3,2)="02","2班","3班"))
望采纳!!!!