☰

Excel 错误为“您输入的参数太少”

tag-icon • tag-icon microsoft-excel worksheet-function
Excel 错误为“您输入的参数太少” 
=IF(AND(TIME(HOUR(B5), MINUTE(B5), SECOND(B5))>TIMEVALUE("6:30 PM"), D5=1), (TIME(hours(C5), MINUTE(C5), SECOND(C5))-TIMEVALUE("9:30 AM")), (TIME(hours(C5), MINUTE(C5), SECOND(C5))-TIMEVALUE("9:30 AM")+TIMEVALUE("9:00 AM")))

给出错误You've entered too few argument

请帮忙。

答案1

我能看到的唯一错误是你正在使用HOURS，它应该是HOUR：

=IF(AND(TIME(HOUR(B5), MINUTE(B5), SECOND(B5))>TIMEVALUE("6:30 PM"), D5=1), (TIME(HOUR(C5), MINUTE(C5), SECOND(C5))-TIMEVALUE("9:30 AM")), (TIME(HOUR(C5), MINUTE(C5), SECOND(C5))-TIMEVALUE("9:30 AM")+TIMEVALUE("9:00 AM")))

相关内容