- 帮我看看这个公式=if(or(AB4<>"",AB4
- =if(or(AB4<>"",AB4<>"旷",AB4<>"事",AB4<>"病"),"假别有误",ROUND(IF(OR(AB4="旷",AB4="事"),N4/21*A4,IF(AB4="病",IF(YEAR(TODAY())-YEAR(F4)+1<10,N4/21*AC4*30%,IF(YEAR(TODAY())-YEAR(F4)+1<20,N4/21*AC4*20%,IF(YEAR(TODAY())-YEAR(F4)+1<30,N4/21*AC4*10%,0))),0)),2)=if(or(AB4
- =IF(AB4="","",IF(OR(AB4="旷",AB4="事",AB4="病"),IF(OR(AB4="旷",AB4="事"),ROUND(N4/21*AC4,2),IF(YEAR(TODAY())-YEAR(F4)+1<10,ROUND(N4/21*AC4*30%,2),IF(YEAR(TODAY())-YEAR(F4)+1<20,round(N4/21*AC4*20%,2),IF(YEAR(TODAY())-YEAR(F4)+1<30,ROUND(N4/21*AC4*10%,2),0)))),"假别有误"))