Is it possible to test a cell using
IF against multiple strings? So for example, I want the function to output
Fruit in cell A2 if cell A1 contains the string
Orange. I can only come up with this in cell A2:
IF(A1 = "Apple"|"Orange", "Fruit", "Not a fruit")
This results in an error.