Hi
I know how to write a basic "IF(OR" statement.
So, for example, if cell A2 had the text "Ball" or "Racket", and we wanted to return the word "Sports," then we could write this in cell B2 =IF(OR(A2="Ball",A2="Racket"),"Sports","")
But this is restrictive, because cell A2 can ONLY...