excel问题怎样用if函数,例;教授工资400,副教授工资300,讲师工资200已 ...答:假设A1为内容单元格,里面的内容为教授,副教授,讲师中的任意一个,B1为工资单元格.则在B1输入:=if(A1="教授",400,if(A1="副教授",300,200)),下拉即可.
请问怎么在此excel表格中用简单的方法将职称栏中的专业、学历,分别...答:H2单元格写入公式 =IF(J2="","",LEFT(J2,FIND(IF(COUNT(FIND("、",J2)),"、",IF(COUNT(FIND(",",J2)),","," ")),J2)-1))下拉复制公式 I2单元格写入公式 =IF(J2="","",RIGHT(J2,LEN(J2)-LEN(H2)-1))或 =IF(J2="","",RIGHT(J2,LEN(J2)-FIND(IF(COUNT(FIND("...