[已解决]公式求简化

...？敏

=IF(B1<0.3,"0:00",IF(B1<1.3,"1:00",IF(B1<2.3,"2:00",IF(B1<3.3,"3:00",IF(B1<4.3,"4:00",IF(B1<5.3,"5:00",IF(B1<6.3,"6:00",IF(B1<7.3,"7:00",IF(B1<8.3,"8:00",IF(B1<9.3,"9:00",IF(B1<10.3,"10:00",IF(B1<11.3,"11:00",IF(B1<12.3,"12:00",IF(B1<13.3,"13:00",IF(B1<14.3,"14:00",IF(B1<15.3,"15:00",IF(B1<16.3,"16:00",IF(B1<17.3,"17:00",IF(B1<18.3,"18:00",IF(B1<18.3,"18:00",IF(B1<19.3,"19:00",IF(B1<20.3,"20:00",IF(B1<21.3,"21:00",IF(B1<22.3,"22:00",IF(B1<23.6,"23:00")))))))))))))))))))))))))

最佳答案

月排行榜 / 总排行榜

砂海

2017-5-8 16:08

=int(b1+.7)&":00"

跳转到最佳答案楼层

327718098

数组公式按ctrl+shift+enter三键及可
=MIN(IF(B1<(ROW(1:24)-0.7),ROW(1:24),""))-1&":00"

砂海

=int(b1+.7)&":00"