Calculated column help
=IF([Chemical Name]="Dioxane","Yes",IF([Chemical Name]="Tetrahydrofuran","Yes",IF([Chemical Name]="2-Propanol","Yes",""))) Is there an easier way to write the function above? I have a list of 20 chemicals that I would like this column to "search for" and show a "Yes" if it finds a match to [Chemical Name].