if函数嵌套left函数用法?答:可以利用IF函数。IF函数与LEFT函数嵌套如下:1、假设C1-1A在A1,在B1中输入:=IF(LEFT(A1,2)="C1","4号楼5单元",IF(LEFT(A1,2)="C2","4号楼4单元",IF(LEFT(A1,2)="C3","4号楼3单元",IF(LEFT(A1,2)="C4","4号楼2元元",IF(LEFT(A1,2)="C5","4号楼1单元",)))。2、...
EXCEL中if函数与left函数嵌套答:可以利用IF函数。IF函数与LEFT函数嵌套如下:1、假设C1-1A在A1,在B1中输入:=IF(LEFT(A1,2)="C1","4号楼5单元",IF(LEFT(A1,2)="C2","4号楼4单元",IF(LEFT(A1,2)="C3","4号楼3单元",IF(LEFT(A1,2)="C4","4号楼2元元",IF(LEFT(A1,2)="C5","4号楼1单元",)))。2、...