Nested If formula

[Balmer07]

Hi,

My head is a bit pickled, I am trying to run an If formula but not getting it right. Can you help?

I need to be able to get the below two formulas to work together for both Beanie and Blanket:

=IF(S2="123",IF(ISNUMBER(SEARCH({"beanie","hat"},R2)),"Beanie"),IF(S2="456","Ignore"))
=IF(S2="123",IF(ISNUMBER(SEARCH("Blanket",R2)),"Blanket"),IF(S2="456","Ignore"))

I'm sure it something simple to include them into 1 formula but just cannot get it

thanks,
Steven

 

[Scott T]

By putting numbers in quotes you turn them into text you are asking if S2= the text value 123 not the number 123. You are also missing the false augment on some of your if statements this will cause the formula to return FALSE since you did not specify what should be returned.

=IF(S2=123,IF(OR(ISNUMBER(SEARCH("beanie",R2)),ISNUMBER(SEARCH("hat",R2))),"beanie","if s2=123 whet R2 is ont beanie or hat goes here"),IF(S2=456,"ignore","if s2<> 123 or 426 goes here"))

=IF(S2="123",IF(ISNUMBER(SEARCH("Blanket",R2)),"Blanket","if s2=123 whet R2 is ont beanie or hat goes here"),IF(S2="456","Ignore","if s2<> 123 or 426 goes here"))

 

[Balmer07]

Sorry amend the 123 to THE and 456 to END

Does this change it for you?