假设A=管理,B

问题描述:

假设A=管理,B

不懂你的意思,是那个领域的公式啊?金融吗?不好意思,没帮上忙,反而要问你.假设1为管理,2为其他时,根据工作年限计发的工资,答案如下:=(G3=1)*((DATEDIF(E3,TODAY(),"m")>=13)*50+(DATEDIF(E3,TODAY(),"m")>=25)*50+(DATEDIF(E3,TODAY(),"m")>=49)*100+(DATEDIF(E3,TODAY(),"m")>=73)*100)+(G3=2)*((DATEDIF(E3,TODAY(),"m")>=13)+(DATEDIF(E3,TODAY(),"m")>=25)+(DATEDIF(E3,TODAY(),"m")>=37)+(DATEDIF(E3,TODAY(),"m")>=60))*50在这里感谢朋友小陈给的答案