“False” result not working on IF formula
Solved/Closed
Related:
- “False” result not working on IF formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Number to words in excel formula - Guide
- Formula spreadsheet definition - Guide
- Excel result sheet grade formula - Guide
3 responses
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.
Jul 16, 2009 at 05:34 PM
Thanks.