[已解决]多条件判断问题

chris_yan23

各位好：
       因根据时间判断完成率达到情况来判断是否正常，求指教，具体参照附件，谢谢了 test.zip (5.12 KB, 下载次数: 6)

2014-9-10 12:46 上传

点击文件名下载附件

最佳答案

月排行榜 / 总排行榜

这儿有肥猫

2014-9-10 12:51

1. =IF(AND(VALUE(TEXT(NOW(),"H"))<12,D3>50%),"正常","异常")

复制代码

跳转到最佳答案楼层

这儿有肥猫

1. =IF(AND(VALUE(TEXT(NOW(),"H"))<12,D3>50%),"正常","异常")

复制代码

baksy

8~17点适用；
=IF(D3>=IF(TEXT(NOW(),"h:m:s")<="12:00:00",TEXT(NOW(),"h:m:s")-"8:00:00","4:00:00"+MAX(TEXT(NOW(),"h:m:s"),"13:00:00")-"13:00:00")/"8:00:00","正常","异常")

易安1

1. =IF(AND(hour(NOW())<12,D3>0.5,"正常","异常")

复制代码