Using IF and OR together

@Sam Walsh

Question 1: Is the string you're looking for just part of the possible value in a cell in the Order column, or is the whole cell equal to ItemA, or ItemB, or ItemC?

Question 2: Are you checking to see if ANY rows in the Order column contain those values, or if just the particular row you're on does?

If you want to check the whole column for the presence of one or more cells that equal any of your three values, you can do this without CONTAINS, but you'll need a COUNTIF in there:

=IF(COUNTIF(Order:Order, OR(@cell = "ItemA", @cell = "ItemB", @cell = "ItemC")) > 1, "Yes", "No")

If you want to check the whole column for the presence of one or more cells that contain any of your three values, you can use CONTAINS:

=IF(OR(CONTAINS("ItemA", Order:Order), CONTAINS("ItemB", Order:Order), CONTAINS("ItemC", Order:Order)), "Yes", "No")

If you just want to check the Order cell on the particular row for your values:

=IF(OR(Order@row = "ItemA", Order@row = "ItemB", Order@row = "ItemC"), "Yes", "No")

If you just want to check if the Order cell on the particular row contains one or more of your values:

=IF(CONTAINS(Order@row = "ItemA", Order@row = "ItemB", Order@row = "ItemC"), "Yes", "No")

Since "A, B or C would be individual cells in the Order column by themselves," either of the first two formulas would work. The first one does it faster with less system overhead.

=IF(COUNTIF(Order:Order, OR(@cell = "ItemA", @cell = "ItemB", @cell = "ItemC")) > 1, "Yes", "No")

The formula with CONTAINS in there three times with have to evaluate the entire column three times, vs once for the first formula. In a big sheet that can cause slowness/reduced response time.