Excel Formulas Tutorials and Expert Advice

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")

 

Home   |   Ask a question   |   Excel Guides   |   Formula Expert Addin   |   FAQs   |   About Us