Hello – I am trying to write a formula that says If Name contains Fred1, Fred2, or if Column B says Blue, or Column C says Leave, then Include (True) or Exclude (False). For example: 

NameSpecificationWhereFred1BlueLeaveFred2BlueStayFred3YellowLeave

Hoping this makes sense, please let me know if otherwise. Thank you, 

​Hello – I am trying to write a formula that says If Name contains Fred1, Fred2, or if Column B says Blue, or Column C says Leave, then Include (True) or Exclude (False). For example:  NameSpecificationWhereFred1BlueLeaveFred2BlueStayFred3YellowLeave Hoping this makes sense, please let me know if otherwise. Thank you,   Read More

​