|Both of these should. Obviously the first one is shorter, but I included the second one just to show you how the AND function can be used within an IF function when you need to check 2 conditions.|
You should not simply use the fomulas as written, you should study them and understand why they work. Following the value_if_true and value_if_false paths for each IF function should help you understand the logic.
Feel free to come back if you can't figure out what's going on.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.