|Do you have a typo in your question? All but one of your conditions compares F5 to other cells. However, you have this odd one: (J5<=G5,4)|
Assuming that's a typo, you can use a Nested IF where your value_if_false is another IF:
Just make sure you close all of your parenthesis at the end.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.