1、=IF(C2="保安",保安基本工资/30*E2，IF(C2="服务",服务基本工资/30*E2，IF(C2="收银",收银基本工资/30*E2)))2、同上3、=IF(DATEDIF(D2,TODAY(),"m")>12,100,IF(DATEDIF(D2,TODAY(),"m")=12,70,IF(DATEDIF(D2,TODAY(),"m")>=6,30,0)))
