excel公式。。。

发布网友 发布时间：2024-10-24 12:00

我来回答

共2个回答

热心网友 时间：2024-11-14 06:08

=if(or(sheet2!a1="教授",sheet2!a1="副教授"),"高级",if(sheet2!a1="讲师","中级",if(sheet2!a1="助教","初级","")))

热心网友 时间：2024-11-14 06:08

假设每个员工在A列。职称在B列，在B1中输入
=if（A1="讲师","中级",if（A1="助教","中级","高级"））

热心网友 时间：2024-11-14 06:08

=if(or(sheet2!a1="教授",sheet2!a1="副教授"),"高级",if(sheet2!a1="讲师","中级",if(sheet2!a1="助教","初级","")))

热心网友 时间：2024-11-14 06:08

假设每个员工在A列。职称在B列，在B1中输入
=if（A1="讲师","中级",if（A1="助教","中级","高级"））

热心网友 时间：2024-11-14 06:08

=if(or(sheet2!a1="教授",sheet2!a1="副教授"),"高级",if(sheet2!a1="讲师","中级",if(sheet2!a1="助教","初级","")))

热心网友 时间：2024-11-14 06:08

假设每个员工在A列。职称在B列，在B1中输入
=if（A1="讲师","中级",if（A1="助教","中级","高级"））

热心网友 时间：2024-11-14 06:08

=if(or(sheet2!a1="教授",sheet2!a1="副教授"),"高级",if(sheet2!a1="讲师","中级",if(sheet2!a1="助教","初级","")))

热心网友 时间：2024-11-14 06:08

假设每个员工在A列。职称在B列，在B1中输入
=if（A1="讲师","中级",if（A1="助教","中级","高级"））

热心网友 时间：2024-11-14 06:08

=if(or(sheet2!a1="教授",sheet2!a1="副教授"),"高级",if(sheet2!a1="讲师","中级",if(sheet2!a1="助教","初级","")))

热心网友 时间：2024-11-14 06:08

假设每个员工在A列。职称在B列，在B1中输入
=if（A1="讲师","中级",if（A1="助教","中级","高级"））

热心网友 时间：2024-11-14 06:08

=if(or(sheet2!a1="教授",sheet2!a1="副教授"),"高级",if(sheet2!a1="讲师","中级",if(sheet2!a1="助教","初级","")))

热心网友 时间：2024-11-14 06:08

假设每个员工在A列。职称在B列，在B1中输入
=if（A1="讲师","中级",if（A1="助教","中级","高级"））