Help! I am brand new to writing formulas, and I cannot seem to get this one to work.
Here is what I am trying to do:
If cell J2 contains "Apple" or "Banana", populate value of cell K2.
I can get them to work separately:
=IF(ISNUMBER(SEARCH("Apple",J2)),K2)
=IF(ISNUMBER(SEARCH("Banana",J2)),K2)
I cannot get them to work together. Here is what I had so far, but clearly I am doing something wrong.
=IF(OR(ISNUMBER(SEARCH("Apple",J2)),K2), IF(ISNUMBER(SEARCH("Banana",J2)),K2))
Any help is appreciated... Explanations are great, I want to learn so I can stop bugging you guys!
Bookmarks