QUESTION
I have a cell that I want to say "Yes" or "NO". If my target cell has the value 3, 4, 5 or 6 then Yes?
ANSWER
The formula for that is a simple =if() formula, try this:
=IF(OR(A1=3,A1=4,A1=5,A1=6),"Yes","No")