I want to correct the below syntax, =if(Search (A8,{"Apple","Apes"},C8,0)
P paradise Member Sep 18, 2022 #1 I want to correct the below syntax, =if(Search (A8,{"Apple","Apes"},C8,0)
V vletm Excel Ninja Sep 18, 2022 #2 paradise Syntaxes =IF(Something is True, then do something, otherwise do something else) =SEARCH(find_text,within_text,[start_num]) =IF(SEARCH(find_text,within_text,[start_num]), then do something, otherwise do something else)
paradise Syntaxes =IF(Something is True, then do something, otherwise do something else) =SEARCH(find_text,within_text,[start_num]) =IF(SEARCH(find_text,within_text,[start_num]), then do something, otherwise do something else)
ETAF Active Member Sep 18, 2022 #3 how about =IF(SUMPRODUCT(--ISNUMBER(SEARCH({"Apple","Apes"},A8)))>0,C8,0)
ETAF Active Member Sep 19, 2022 #5 =SUMPRODUCT(--ISNUMBER(SEARCH({"Apple","Apes"},AC8))) will return a zero if not found , a 1 if either apples or apes are found in string - 2 if both are found only get an error if cell ac8 has an error a you looking for that sort of result ? i'm away for a couple of days - and may not get a chance to reply further -
=SUMPRODUCT(--ISNUMBER(SEARCH({"Apple","Apes"},AC8))) will return a zero if not found , a 1 if either apples or apes are found in string - 2 if both are found only get an error if cell ac8 has an error a you looking for that sort of result ? i'm away for a couple of days - and may not get a chance to reply further -