举报
pollyliu123
一个IF后面对就一个括号,后再加两层括号。 你这个可改为=IF(OR(C2="保安",C2="收银"),2100/30*E2,IF(C2="服务",2050/30*E2,IF(C2="保洁",1500/30*E2,IF(C2="售币",2000/30*E2,0)))) =IF(D2="","",IF(AND(DATEDIF(D2,TODAY(),"Ym")>=6,DATEDIF(D2,TODAY(),"Y")>=1),30+DATEDIF(D2,TODAY(),"Y")*100,IF(DATEDIF(D2,TODAY(),"Y")>=1,DATEDIF(D2,TODAY(),"Y")*100,IF(DATEDIF(D2,TODAY(),"m")>=6,30,0))))