我在做一个excel 第一列输入人名 第二列自动返回人名所属系别 如a1输入 小王 b1自动返回 计科系
我曾经用if嵌套来表示但是嵌套到第八层就无法进行了 只有分成几次才能 如:
=IF(A1="韩雪","政法系",IF(A1="彭利","政法系",IF(A1="彭利","政法系",IF(A1="古威","计科系",IF(A1="苏凌函","计科系")))))&IF(A1="郭晗昕","计科系",IF(A1="张丽莉","中加班",IF(A1="周俊霞","体表系",IF(A1="李茜","心理系",IF(A1="李智"," 管理系")))))
我没分了,这是为什么呢?
=IF(A1="贺元桦","财税系",IF(A1="文宇","财税系",IF(A1="王菲菲","财税系")))&IF(A1="牟金星","财税系",IF(A1="李斓","外语系",IF(A1="刘刚","外语系",IF(A1="邱楠","外语系",IF(A1="孙建","外语系",IF(A1="黄鑫","艺术系"))))))&IF(A1="李慧超","艺术系",IF(A1="张申华","艺术系",IF(A1="田蜜","艺术系",IF(A1="陆明桦","艺术系"))))
求解啊,可以用vba还是什么函数请详细点谢谢
|