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!
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!