前面是每次迟到的分钟,在迟到扣款栏,求如果每次迟到1-10分钟扣10元,迟...答:假设第一个迟到时间从B2开始,参考下面公式,并下拉 =SUM(IF(ISNUMBER(B2),IF(B2<=10,10,IF(B2<=20,20,IF(B2<=30,$A$1/$B$1/2,$A$1/$B$1))),(IF(ISNUMBER(C2),IF(C2<=10,10,IF(C2<=20,20,IF(C2<=30,$A$1/$B$1/2,$A$1/$B$1))),(IF(ISNUMBER(D2),IF(D2<...