A little help with nested if

[ShayAA]

Hi,

Can someone please help me to create a nested if?

Basically, I want to check if a cell contains a string, and if not, check if it contains another string and so on.

My cell is A2.

If A2 contains the word "bracelet", A10 = "bracelet"
If A2 contains the word "necklace", A10 = "necklace"
If A2 contains the word "anklet", A10 = "anklet"
If A2 contains the word "earring", A10 = "earring"

Thanks!

 

[Rorylfc]

=IF(A2="bracelet","bracelet",IF(A2="necklace","necklace",IF(A2="anklet","anklet",IF(A2="earring","earring","Not defined, check!!"))))

Enter the formula into A10.
You might want to change the "Not defined, check!!" bit to something more approriate..

 

[ShayAA]

Thanks, but I don't want to check if it equals to "bracelet" but contains the words bracelet, since it could be "red 10in bracelet - large" as an example.

 

[Rorylfc]

Sorry I misread your requirement...

 

[Rorylfc]

Try this

=IF(ISNUMBER(SEARCH("bracelet",A2)),"bracelet",IF(ISNUMBER(SEARCH("necklace",A2)),"necklace",IF(ISNUMBER(SEARCH("anklet",A2)),"anklet",IF(ISNUMBER(SEARCH("earring",A2)),"earring","Not defined, check!!"))))

Not very elegant.. but should do the job

 

[Snakehips]

Try...
=IF(ISNUMBER(FIND("bracelet",A2,1)),"bracelet", IF(ISNUMBER(FIND("necklace",A2,1)),"necklace",IF(ISNUMBER(FIND("anklet",A2,1)),"anklet",IF(ISNUMBER(FIND("earing",A2,1)),"earing","No Match"))))

Cross posted over Rory -Ditto

 

[ShayAA]

Thank you both. Works like a charm! ray: