Hello!
Given this formula:
=IF(OR(HOUR(AN2)+INT(AN2)*24 < 120, AND(HOUR(AN2)+INT(AN2)*24 = 0, MINUTE(AN2)+INT(AN2)*60 = 0, SECOND(AN2)+INT(AN2)*60 < 60)), IF(((100*(AN2/$AP$2))-100)/100 <> -1, ((100*(AN2/$AP$2))-100)/100, 0), "INVALID")
Essentially, if the time entered is 120 hours or greater, or is 59 seconds or less, the cell should display "INVALID".
But a time of 0:00:02 is not displaying "INVALID".
I can't seem to figure out why. Any suggestions?
Given this formula:
=IF(OR(HOUR(AN2)+INT(AN2)*24 < 120, AND(HOUR(AN2)+INT(AN2)*24 = 0, MINUTE(AN2)+INT(AN2)*60 = 0, SECOND(AN2)+INT(AN2)*60 < 60)), IF(((100*(AN2/$AP$2))-100)/100 <> -1, ((100*(AN2/$AP$2))-100)/100, 0), "INVALID")
Essentially, if the time entered is 120 hours or greater, or is 59 seconds or less, the cell should display "INVALID".
But a time of 0:00:02 is not displaying "INVALID".
I can't seem to figure out why. Any suggestions?