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 multiple text then return value
If cell contains text then return value multiple conditions - Best answers
Excel if cell contains word then assign value - 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 w/ date in test cell ✓ - Excel Forum
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - 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!