Multiple IF formula

Hi I am unable to figure this out.

I need a formula that says: If any of the cells Barcode:Barcode contain the term "1 In Production", then add the text "In Production" to corresponding [In Production]1" cell.

Find more posts tagged with

Formulas

Comments

Martin Polášek

Solved...=IF(COUNTIF(Barcode:Barcode, "1 In Production") > 0, "In Production", "")

Travis

Thanks for updating us with your solution!