D2=TEXT((C2=C$2)*(B2-G$1>0)+(C2=C$3)*(B2-G$2<0)*2-1,"早退;;遲到")
另解=IF(SUM(FREQUENCY(B2*1,G$1:G$2-{0;"1E-9"})*{1;2;3})=2,IF(C2=C$2,"遲到","早退"),"")
另解=IF((C2="上班")*(B2/1>G$1),"遲到",IF((C2="下班")*(B2/1<G$2),"早退",""))
另解=IF(C2=C$2,IF(B2-G$1>0,"遲到",""),IF(B2-G$2<0,"早退",""))
留言
張貼留言