“False” result not working on IF formula
Solved/Closed
Di
-
Jul 16, 2009 at 11:49 AM
aquarelle
aquarelle
- Posts
- 7104
- Registration date
- Saturday April 7, 2007
- Status
- Anonymous
- Last seen
- May 24, 2022
Related:
- “False” result not working on IF formula
- How to remove the false result in excel ✓ - Forum - Office Software
- Need help to remove FALSE from cell ✓ - Forum - Office Software
- Removing a 'FALSE' result ✓ - Forum - Office Software
- Removing False Value ✓ - Forum - Excel
- Removing false in excel ✓ - Forum - Excel
3 replies
aquarelle
Jul 16, 2009 at 04:03 PM
- Posts
- 7104
- Registration date
- Saturday April 7, 2007
- Status
- Anonymous
- Last seen
- May 24, 2022
Jul 16, 2009 at 04:03 PM
Hello,
Try with this formula :
=IF(AND(HOUR(Z2)>11,MINUTE(Z2)>=0,SECOND(Z2)>=0),"Afternoon","Morning")
Best regards
Try with this formula :
=IF(AND(HOUR(Z2)>11,MINUTE(Z2)>=0,SECOND(Z2)>=0),"Afternoon","Morning")
Best regards
This is what I’ve been trying to accomplish if cell Z2 less than 12 return Morning, if less than 16 return Afternoon, if less than 18 return Evening, if less than 20 return Night, if any other time return Closed.
This is the formula I used that works:
=IF(AND(HOUR(X2)<12)|"Morning"|IF(AND(HOUR(X2)<16)|"Afternoon"|IF(AND(HOUR(X2)<18)|"Evening"|IF(AND(HOUR(X2)<20)|"Night"|"Closed"))))
Thank you "AQUARELLE" for starting me on the right track.
This is the formula I used that works:
=IF(AND(HOUR(X2)<12)|"Morning"|IF(AND(HOUR(X2)<16)|"Afternoon"|IF(AND(HOUR(X2)<18)|"Evening"|IF(AND(HOUR(X2)<20)|"Night"|"Closed"))))
Thank you "AQUARELLE" for starting me on the right track.
aquarelle
Jul 17, 2009 at 12:24 PM
- Posts
- 7104
- Registration date
- Saturday April 7, 2007
- Status
- Anonymous
- Last seen
- May 24, 2022
Jul 17, 2009 at 12:24 PM
Hi,
Happy to learn that my formula has been able to put you in the right track. I wish you good continuation. :)
Best regards
Happy to learn that my formula has been able to put you in the right track. I wish you good continuation. :)
Best regards
Jul 16, 2009 at 05:34 PM
Thanks.