Multiple IF(AND Statements in Single Cell

[brandon12]

I am attempting to combine the below formulas into one cell in an effort to return 1 of 4 option based upon my data and criteria in cell F2:

=IF(AND(E2>=TIMEVALUE("6:00:00 AM"),E2<=TIMEVALUE("11:59:00 AM")),"MORNING")
=IF(AND(E2>=TIMEVALUE("12:00:00 PM"),E2<=TIMEVALUE("6:00:00 PM")),"AFTERNOON")
=IF(AND(E2>=TIMEVALUE("6:01:00 PM"),E2<=TIMEVALUE("11:59:00 PM")),"EVENING")
=IF(AND(E2>=TIMEVALUE("12:00:00 AM"),E2<=TIMEVALUE("5:59:00 AM")),"EARLY BIRD")

Any ideas? Thanks!

 

[DanteAmor]

Try this

=IF(E2 < TIMEVALUE("06:00"),"EARLY BIRD",IF(E2 < TIMEVALUE("12:00"),"Morning",IF(E2 < TIMEVALUE("18:00"),"AFTERNOON",IF(E2 < TIMEVALUE("23:59"),"EVENING"))))

<timevalue("06:00"),"early bird",if(e2<timevalue("12:00"),"morning",if(e2<timevalue("18:00"),"afternoon",if(e2<timevalue("23:59"),"evening"))))<="" html=""></timevalue("06:00"),"early>

 

[brandon12]

Thank you! Works great.

 

[DanteAmor]

Try this:

=LOOKUP(TEXT(E2,"hh:mm"),{"00:00","06:00","12:00","18:00"},{"EARLY BIRD","MORNING","AFTERNOON","EVENING"})