Formula for if cell contains word, assign value for multiple

 Blocked Profile -

I am looking for a formula to help me assign a value for multiple words and values.

If column A has the contains Apple, assign X. IF it contains grape OR banana, assign Y. If it contains neither, (or all other values) assign z.

Pretty complicated but would be cool to know.


1 reply

OK, the syntax for IF is as follows:

So, an example of such would be:
In cell a3 set "=IF(a1="Widget","123","")"

So if you were to put Widget, in cell A1, Cell A3 would have an "123".

You can then NEST if statements, for the other values. Like so:

I hope you understand this example.