EXCEL函数如何设置,关于时间节点的公示答:E2输入:=IF(AND(C7<>"",C7<=B7),"已完成",IF(AND(C7<>"",C7<=D7),"延期完成",IF(OR(AND(TODAY()>B7,D7=""),AND(D7<>"",TODAY()>D7)),"未完成",IF(AND(B7-TODAY()<=7,B7-TODAY()>=0),"预警",IF(D7-TODAY()<=7,"延期预警","")))(对D列的理解,计划完成...
关于excel中请假时间差的问题?答:=IF(OR(F3="事假",F3="请假"),IF(AND(D3<$G$1,E3>$H$1),(HOUR(E3-D3)-2)*60+MINUTE(E3-D3),(HOUR(E3-D3))*60+MINUTE(E3-D3)),"")=IF(F6="公出",IF(AND(D6<$G$1,E6>$H$1),(HOUR(E6-D6)-2)*60+MINUTE(E6-D6),(HOUR(E6-D6))*60+MINUTE(E6-D6)),...