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

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

以下是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)&"分钟的班","下午正常到岗"))),"")),"早上正常到岗")