excel多条件判断公式

E2=IF(AND(D2>=TIME(8,0,0),D2<=TIME(20,0,0)),"day",IF(AND(D2>=TIME(0,0,0),D2<=TIME(8,0,0)),"night2",IF(AND(D2>=TIME(20,0,0),D2<=TIME(23,0,0)),"night1","b")))

 

C语言表达方式:

if(D2>=TIME(8,0,0)&&D2<=TIME(20,0,0))//满足条件：8:00-20:00之间的数据

{

E2="day";

}

else if(D2>=TIME(0,0,0)&&D2<=TIME(8,0,0))//满足条件：0:00-8:00之间的数据

{

E2="night2";

}

else if(D2>=TIME(20,0,0)&&D2<=TIME(23,0,0))//满足条件：20:00-23:00之间的数据

{

E2="night1";

}