请教if命令如何递进逻辑判断

答案:1 悬赏:40 手机版

解决时间 2021-11-08 21:32

提问者网友：饥饿走向夜
2021-11-08 18:33

请教if命令如何递进逻辑判断

最佳答案

五星知识达人网友：污到你湿
2021-11-08 19:18

以下是excel 的编程，理解起来比较简单
=IF(TEXT(E13,"HH:MM:SS")>TEXT(参数!$C$2&":"&参数!$D$2&":"&参数!$E$2,"HH:MM:SS"),IF(TEXT(E13,"HH:MM:SS")<=TEXT(参数!$C$3&":"&参数!$D$3&":"&参数!$E$3,"HH:MM:SS"),"您早上迟到了""IENT(VALUE(TEXT(LEFt(E13,FIND(":",E13)),"HH")-VALUE(参数!$C$2))*60+(LEFt(RIGHt(E13,5),FIND(":",RIGHt(E13,5))-1)-VALUE(参数!$D$2)),60)&"小时"&MOD(VALUE(TEXT(LEFt(E13,FIND(":",E13)),"HH")-VALUE(参数!$C$2))*60+(LEFt(RIGHt(E13,5),FIND(":",RIGHt(E13,5))-1)-VALUE(参数!$D$2)),60)&"分钟",IF(TEXT(E13,"HH:MM:SS")>=TEXT(参数!$C$3&":"&参数!$D$3&":"&参数!$E$3,"HH:MM:SS"), IF(TEXT(E13,"HH:MM:SS")<=TEXT(参数!$C$4&":"&参数!$D$4&":"&参数!$E$4,"HH:MM:SS"),"中午休息", IF(TEXT(E13,"HH:MM:SS")=1, "您加了""IENT(VALUE(TEXT(LEFt(E13,FIND(":",E13)),"HH")-VALUE(参数!$C$6))*60+(LEFt(RIGHt(E13,5),FIND(":",RIGHt(E13,5))-1)-VALUE(参数!$D$6)),60)&"小时"&MOD(VALUE(TEXT(LEFt(E13,FIND(":",E13)),"HH")-VALUE(参数!$C$6))*60+(LEFt(RIGHt(E13,5),FIND(":",RIGHt(E13,5))-1)-VALUE(参数!$D$6)),60)&"分钟的班","下午正常到岗"))),"")),"早上正常到岗")

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息