I want cell I2 to autofill the text "completed" only if cell M2 contains the text "t4" or "tfour"

https://i.stack.imgur.com/P1Ar8.png

CodePudding user response：

To set values, use a formula =IF(OR(A11="t4", A11="tfour"), "completed", "incomplete")