Forum Discussion

Copper Contributor

Nov 19, 2019

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...

function

sharepoint

Robin Nilsson

Bronze Contributor

Nov 19, 2019

gopalaraoa Still long but you can use math and not have to deal with lots of parentheses...

IF([Chemical Name]="Dioxane",1,0) + IF([Chemical Name]="Tetrahydrofuran",1,0) + IF([Chemical Name]="2-Propanol",1,0)

Then, wrap that whole thing in an if statement

iF(theAboveVeryLongStatement > 0, "Yes", "")