Multiple choices in IF function

Multiple choices in IF function

Hi I want to use the "if" function to return a value based on the text in an adjacent cell, however I want it to retrun true for more than one vaue.
ie IF A1 = "red" or "orange", "Yes", "no"
How do I do the OR bit?
 
Thanks

Keys to the Problem Multiple choices in IF function

Download Error Fixer (Free)

=if(or(a1="red",a1="orange"),"Yes","No")
or
=IF(OR(a1="red","orange"),"Yes","No")
Will work

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Recommended Method to Repair the Problem: Multiple choices in IF function:

 

 

How to Fix Multiple choices in IF function with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Run it, and it will scan your system. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.

Related: 50% Of The Times I Am In A MS Word, Or In An Email, And I Press Enter To Go To The Next Line To Continue Writing, Windows Mobility Center" Screen Shows Up.,Adobe Flash Player For Window 7,After Last Updates My Microsoft Word Starter 2010 Won't Work,Automatically Deleting Blank Characters Before Text In Line,Administrative Tools In Control Panel Is Blank. What Can I Do To Restore It?,Windows Backup And Restore Keep Popping Up,MS Word Starter, Omission Of Character,If I Use Two Or More Registry Cleaner. Does It Creat Any Problem To My Computer?,Screen Shot? - How To Take A Screen Shot,Parental Controls Not Working
Read More: How Can I Fix - trying to find a template for mini booklet from a single 8x11 page?,Troubleshooter of Error: Can anyone advise how I can set desktop as the default screen that opens when I log in to Win 8?,Troubleshoot:Excel 2007: Charts - One line not showing in chart,How Can You Fix - Converting Works spreadsheets to Excel format without having Works loaded?,My troubleshooter keeps telling me it has an error and stops working.,several programs in the control panel wont allow me to access them, i dont think it's a virus. windows 7,How do I edit data in an embedded Excel object in a Word form document?,Message pops when I start FSX with an error code, stating that it was not possible to activate the product. Shuts down after 30 minutes of gameplay. HELP!,Excel Doc. won't launch in separate window