Formula for if cell contains word, assign value for multiple

hdiesel - Jan 14, 2016 at 04:43 PM
 Blocked Profile - Jan 14, 2016 at 04:50 PM

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 response

Blocked Profile
Jan 14, 2016 at 04:50 PM
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.