excel - 嵌套 IF 公式失败

Question

我编写了 Excel 的嵌套IF函数来对时间戳进行分类（代码如下所示）。该代码在某些单元格中失败并在其他单元格中工作。该列的格式正确。

=IF(AND([@TIME]>=TIMEVALUE("5:00:00"), [@TIME]<=TIMEVALUE("11:59:59")), "MORNING BELT", 
 IF(AND(B505>= TIMEVALUE("12:00:00"), B505<=TIMEVALUE("17:59:59")), "AFTERNOON BELT", 
 IF(AND(B505>=TIMEVALUE("18:00:00"), B505<=TIMEVALUE("20:59:59")), "EVENING BELT", 
 IF(AND(B505>=TIMEVALUE("21:00:00"), B505<=TIMEVALUE("23:59:59")), "NIGHT BELT", 
 IF(AND(B505>=TIMEVALUE("00:00:00"), B505<=TIMEVALUE("4:59:59")), "MIDNIGHT BELT","")))))

标签： excelexcel-formula