急问QAQ这个基本工资和工龄工资的if函数怎么写啊?表格里是参加工作时...答:基本工资:=IF(H2="教授",2800,IF(H2="副教授",2500,IF(H2="讲师",2000,IF(H2="助教",1800,IF(H2="其他",1500,)))工龄工资:=IF(DATEDIF(F2,L2,"Y")>=20,400,IF(DATEDIF(F2,L2,"Y")>=15,200,IF(DATEDIF(F2,L2,"Y")>=10,100,)))其中“L”列是截止日期, F列是开始工作...