Help with =IF ISNUMBER for combined answers

[annaskarr]

Hello! I have an issue that I'd love some help on. Say Column A might contain the text "Red Apples", or it might contain "30 Oranges", or it might contain "Washingtonian Apples and Floridian Oranges", or it might contain some other stuff. If I want to make another column next to it that will search for those specific things and if it finds Apples, return "Apples", if it finds Oranges, return "Oranges", and if it finds both of those terms, return "Apples and Oranges". Is this something I can throw together with the =IF(ISNUMBER(SEARCH)) function? My current musings are in the vein of

=IF(ISNUMBER(SEARCH"*Apple*",A1)),"Apple",IF(ISNUMBER(SEARCH("*Orange*",A1)),"Orange")),IF(AND(ISNUMBER(SEARCH("*Apple*",A1)),(ISNUMBER(SEARCH("*Orange*",A1)),"Apples and Oranges")))

Can someone tell me why it's erroring out, or if there's a better/more efficient way to accomplish this?

 

[Fluff]

How about

=IF(AND(ISNUMBER(SEARCH("*Apple*",A1)),ISNUMBER(SEARCH("*Orange*",A1))),"Apples and Oranges",IF(ISNUMBER(SEARCH("*Apple*",A1)),"Apple",IF(ISNUMBER(SEARCH("*Orange*",A1)),"Orange","")))

 

[Joe4]

How about

=IF(AND(ISNUMBER(SEARCH("*Apple*",A1)),ISNUMBER(SEARCH("*Orange*",A1))),"Apples and Oranges",IF(ISNUMBER(SEARCH("*Apple*",A1)),"Apple",IF(ISNUMBER(SEARCH("*Orange*",A1)),"Orange","")))

Fluff, correctly me if I am wrong, but when using SEARCH, you don't need wildcards, right? Aren't they unnecessary?
i.e.

SEARCH("*Apple*",A1)

could just be simplified to:

SEARCH("Apple",A1)

and the same thing for all the other SEARCH functions.

 

[Fluff]

when using SEARCH, you don't need wildcards, right? Aren't they unnecessary?

Yes they are, I just forgot to take them out.