IF OR AND excel formula with multiple output

I am trying to write an if or and excel formula which will return a statement and the statement can be from 4 categories.

I have two variables and in order to return a statement the two parameters need to be satisfied.

The current formula i am using is as per below:

=IF(OR(AND(D4>1799,E4>"07:59"),AND(D4>900,E4>"05:59"),AND(D4>350,E4>"04:59"),AND(D4>0,E4>"07:59")),"Red","Amber")

However I am missing 2 other output "Green" and "Yellow"

can someone help me please?