“False” result not working on IF formula
Solved/Closed
Di

Jul 16, 2009 at 11:49 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024  Jul 17, 2009 at 12:24 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024  Jul 17, 2009 at 12:24 PM
Related:
 “False” result not working on IF formula
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Date formula in excel dd/mm/yyyy  Guide
 Position formula in excel  Office Software Forum
 Number to words in excel formula  Guide
 Excel grade formula  Guide
3 responses
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Jul 16, 2009 at 04:03 PM
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
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Jul 17, 2009 at 12:24 PM
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.