... <看更多>
Search
Search
... <看更多>
You need to first check if E2 is blank and then proceed with ISNUMBER if true =IF(ISBLANK(E$2), FALSE, ISNUMBER(SEARCH(E$2,$A3))). ... <看更多>
What result are you getting? Not seeing any issues. Tested in SharePoint Online =IF(ISNUMBER(SEARCH("Assessing",ColumnA)),"Internal" ... ... <看更多>
Let's add the ISNUMBER function to the logic of our previous SEARCH function. =ISNUMBER(SEARCH(“AT”,A5)). Any cell that contained a numeric response is now ... ... <看更多>