I am finetuning the data I collected for my thesis. I have 1 column in which a cell can take the value or 1, 2, 3, 4 or 5. I want to make a column next this one in which I want to put the condition that if a cell takes the value of 1 or 3 it must say No Strategy and on the other hand if the cell takes a value of 2, 4 or 5 it must say Use Response Strategy. I've been trying IF and OR formulas but it doesn't work. Please help me.
Solved by B. F. in 20 mins