Formula for if cell contains word, assign value for multiple

Closed

Excel

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

Hello,

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.

Thanks!

If cell contains text then return value multiple conditions
If cell contains multiple text then return value - Best answers
If cell contains multiple specific text - Best answers
If a cell has text then return value ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Excel: If Date =, then enter a value ✓ - Excel Forum
Excel - IF function with multiple words ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum

1 response

Answer 1 / 1

Blocked Profile
Jan 14, 2016 at 04:50 PM

OK, the syntax for IF is as follows:
[code]
=IF(LOGIC_TEST,TRUE,FALSE)
/code

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:
=IF(a1="Widget","123",if(a1="Sprocket","999",if(a1="Hinge","567","NONE")))

I hope you understand this example.

Similar discussions

Excel - IF function with multiple words

If a cell contains any text then add a value

Copy data onto sheet only if cell has text

Find word within cell & put value in adjacent

Excel if range of cell contain a text put a cell value in

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!