某列编号A01 A02...B01B02..C01C02...编号中第一个字母表示要返回的科室:A-基础室,B-计算机,C-电子室 求高手解答
第1个回答 2011-05-20
假设编号在A列
B1输入公式 =lookup(left(a1),{"A","B","C"},{"基础室","计算机","电子室"})
公式下拉
如果一定要用if
则 =if(left(a1)="A","基础室",if(left(a1)="B","计算机",if(left(a1)="C","电子室","")))
B1输入公式 =lookup(left(a1),{"A","B","C"},{"基础室","计算机","电子室"})
公式下拉
如果一定要用if
则 =if(left(a1)="A","基础室",if(left(a1)="B","计算机",if(left(a1)="C","电子室","")))
第2个回答 2011-05-20
=if(left(A1,1)="A","基础室",if(left(A1,1)="B","计算机","电子室"))
第3个回答 2011-05-20
B1单元格中输入
=IF(LEFT(A1)="A","基础室",IF(LEFT(A1)="B","计算机",IF(LEFT(A1)="C","电子室")))
再下拉,即可。
=IF(LEFT(A1)="A","基础室",IF(LEFT(A1)="B","计算机",IF(LEFT(A1)="C","电子室")))
再下拉,即可。
第4个回答 2011-05-20
=IF(LEFT(A1,1)="A","基础室",IF(LEFT(A1,1)="B","计算机",IF(LEFT(A1,1)="C","电子室")))本回答被提问者采纳
第5个回答 2011-05-20
假设数据在D列,输入公式
=LOOKUP(LEFT(D1,1),{"A","B","C"},{"基础室","计算机","电子室"})
=LOOKUP(LEFT(D1,1),{"A","B","C"},{"基础室","计算机","电子室"})