一、逻辑函数IF 函数在教务中的应用 利用IF函数根据学号判断学生班级 =IF(LEFT(B15,1)="7","七",IF(LEFT(B15,1)="8","八","九"))&MID(B15,2,2)*1&"班"